--
-- PostgreSQL database dump
--

-- Dumped from database version 12.7
-- Dumped by pg_dump version 12.3

-- Started on 2024-08-29 16:12:40

SET application_name = securedump;
SET ROLE = sysdba;
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- TOC entry 44 (class 2615 OID 16429)
-- Name: ruoyi2; Type: SCHEMA; Schema: -; Owner: sysdba
--

CREATE SCHEMA ruoyi2;


ALTER SCHEMA ruoyi2 OWNER TO sysdba;

--
-- TOC entry 1782 (class 1255 OID 16433)
-- Name: cast_boolean_to_smallint(boolean); Type: FUNCTION; Schema: ruoyi2; Owner: sysdba
--

CREATE FUNCTION ruoyi2.cast_boolean_to_smallint(boolean) RETURNS smallint
    LANGUAGE sql STRICT
    AS $_$
select oracle.decode($1::boolean,'f'::boolean,0::smallint,'t'::boolean,1::smallint,true);
$_$;


ALTER FUNCTION ruoyi2.cast_boolean_to_smallint(boolean) OWNER TO sysdba;

--
-- TOC entry 1781 (class 1255 OID 16432)
-- Name: find_in_set(anyelement, character varying); Type: FUNCTION; Schema: ruoyi2; Owner: sysdba
--

CREATE FUNCTION ruoyi2.find_in_set(v1 anyelement, v2 character varying) RETURNS boolean
    LANGUAGE sql
    AS $$
    Select cast(v1 as text) = any(string_to_array(v2,','));
$$;


ALTER FUNCTION ruoyi2.find_in_set(v1 anyelement, v2 character varying) OWNER TO sysdba;

--
-- TOC entry 1780 (class 1255 OID 16431)
-- Name: substring_index(character varying, character varying, integer); Type: FUNCTION; Schema: ruoyi2; Owner: sysdba
--

CREATE FUNCTION ruoyi2.substring_index(character varying, character varying, integer) RETURNS character varying
    LANGUAGE plpgsql IMMUTABLE STRICT
    AS $_$
DECLARE
tokens varchar[];
length integer ;
indexnum integer;
BEGIN
tokens := pg_catalog.string_to_array($1, $2);
length := pg_catalog.array_upper(tokens, 1);
indexnum := length - ($3 * -1) + 1;
IF $3 >= 0 THEN
RETURN pg_catalog.array_to_string(tokens[1:$3], $2);
ELSE
RETURN pg_catalog.array_to_string(tokens[indexnum:length], $2);
END IF;
END;
$_$;


ALTER FUNCTION ruoyi2.substring_index(character varying, character varying, integer) OWNER TO sysdba;

--
-- TOC entry 283 (class 1259 OID 16435)
-- Name: seq_gen_table_table_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_gen_table_table_id
    START WITH 1
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_gen_table_table_id OWNER TO sysdba;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- TOC entry 284 (class 1259 OID 16437)
-- Name: gen_table; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.gen_table (
    table_id bigint DEFAULT nextval('ruoyi2.seq_gen_table_table_id'::regclass) NOT NULL,
    table_name character varying(200) DEFAULT ''::character varying,
    table_comment character varying(500) DEFAULT ''::character varying,
    sub_table_name character varying(64),
    sub_table_fk_name character varying(64),
    class_name character varying(100) DEFAULT ''::character varying,
    tpl_category character varying(200) DEFAULT 'crud'::character varying,
    package_name character varying(100),
    module_name character varying(30),
    business_name character varying(30),
    function_name character varying(50),
    function_author character varying(50),
    gen_type character(1) DEFAULT '0'::bpchar,
    gen_path character varying(200) DEFAULT '/'::character varying,
    options character varying(1000),
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi2.gen_table OWNER TO ruoyi;

--
-- TOC entry 7121 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.table_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.table_id IS '编号';


--
-- TOC entry 7122 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.table_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.table_name IS '表名称';


--
-- TOC entry 7123 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.table_comment; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.table_comment IS '表描述';


--
-- TOC entry 7124 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.sub_table_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.sub_table_name IS '关联子表的表名';


--
-- TOC entry 7125 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.sub_table_fk_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.sub_table_fk_name IS '子表关联的外键名';


--
-- TOC entry 7126 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.class_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.class_name IS '实体类名称';


--
-- TOC entry 7127 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.tpl_category; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.tpl_category IS '使用的模板（crud单表操作 tree树表操作）';


--
-- TOC entry 7128 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.package_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.package_name IS '生成包路径';


--
-- TOC entry 7129 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.module_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.module_name IS '生成模块名';


--
-- TOC entry 7130 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.business_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.business_name IS '生成业务名';


--
-- TOC entry 7131 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.function_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.function_name IS '生成功能名';


--
-- TOC entry 7132 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.function_author; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.function_author IS '生成功能作者';


--
-- TOC entry 7133 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.gen_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.gen_type IS '生成代码方式（0zip压缩包 1自定义路径）';


--
-- TOC entry 7134 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.gen_path; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.gen_path IS '生成路径（不填默认项目路径）';


--
-- TOC entry 7135 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.options; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.options IS '其它生成选项';


--
-- TOC entry 7136 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.create_by IS '创建者';


--
-- TOC entry 7137 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.create_time IS '创建时间';


--
-- TOC entry 7138 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.update_by IS '更新者';


--
-- TOC entry 7139 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.update_time IS '更新时间';


--
-- TOC entry 7140 (class 0 OID 0)
-- Dependencies: 284
-- Name: COLUMN gen_table.remark; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table.remark IS '备注';


--
-- TOC entry 285 (class 1259 OID 16452)
-- Name: seq_gen_table_column_column_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_gen_table_column_column_id
    START WITH 1
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_gen_table_column_column_id OWNER TO sysdba;

--
-- TOC entry 286 (class 1259 OID 16454)
-- Name: gen_table_column; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.gen_table_column (
    column_id bigint DEFAULT nextval('ruoyi2.seq_gen_table_column_column_id'::regclass) NOT NULL,
    table_id bigint,
    column_name character varying(200),
    column_comment character varying(500),
    column_type character varying(100),
    java_type character varying(500),
    java_field character varying(200),
    is_pk character(1),
    is_increment character(1),
    is_required character(1),
    is_insert character(1),
    is_edit character(1),
    is_list character(1),
    is_query character(1),
    query_type character varying(200) DEFAULT 'EQ'::character varying,
    html_type character varying(200),
    dict_type character varying(200) DEFAULT ''::character varying,
    sort integer,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone
);


ALTER TABLE ruoyi2.gen_table_column OWNER TO ruoyi;

--
-- TOC entry 7141 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.column_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.column_id IS '编号';


--
-- TOC entry 7142 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.table_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.table_id IS '归属表编号';


--
-- TOC entry 7143 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.column_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.column_name IS '列名称';


--
-- TOC entry 7144 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.column_comment; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.column_comment IS '列描述';


--
-- TOC entry 7145 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.column_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.column_type IS '列类型';


--
-- TOC entry 7146 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.java_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.java_type IS 'JAVA类型';


--
-- TOC entry 7147 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.java_field; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.java_field IS 'JAVA字段名';


--
-- TOC entry 7148 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.is_pk; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.is_pk IS '是否主键（1是）';


--
-- TOC entry 7149 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.is_increment; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.is_increment IS '是否自增（1是）';


--
-- TOC entry 7150 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.is_required; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.is_required IS '是否必填（1是）';


--
-- TOC entry 7151 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.is_insert; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.is_insert IS '是否为插入字段（1是）';


--
-- TOC entry 7152 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.is_edit; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.is_edit IS '是否编辑字段（1是）';


--
-- TOC entry 7153 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.is_list; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.is_list IS '是否列表字段（1是）';


--
-- TOC entry 7154 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.is_query; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.is_query IS '是否查询字段（1是）';


--
-- TOC entry 7155 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.query_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.query_type IS '查询方式（等于、不等于、大于、小于、范围）';


--
-- TOC entry 7156 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.html_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.html_type IS '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）';


--
-- TOC entry 7157 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.dict_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.dict_type IS '字典类型';


--
-- TOC entry 7158 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.sort; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.sort IS '排序';


--
-- TOC entry 7159 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.create_by IS '创建者';


--
-- TOC entry 7160 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.create_time IS '创建时间';


--
-- TOC entry 7161 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.update_by IS '更新者';


--
-- TOC entry 7162 (class 0 OID 0)
-- Dependencies: 286
-- Name: COLUMN gen_table_column.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.gen_table_column.update_time IS '更新时间';


--
-- TOC entry 495 (class 1259 OID 479912)
-- Name: list_column; Type: VIEW; Schema: ruoyi2; Owner: sysdba
--

CREATE VIEW ruoyi2.list_column AS
 SELECT columns.table_catalog,
    columns.table_schema,
    columns.table_name,
    columns.ordinal_position AS sort,
    columns.column_name,
    columns.data_type AS typename,
        CASE
            WHEN (((columns.is_nullable)::text = 'no'::text) AND (c.contype <> 'p'::"char")) THEN '1'::text
            ELSE NULL::text
        END AS is_required,
        CASE
            WHEN (c.contype = 'p'::"char") THEN '1'::text
            ELSE '0'::text
        END AS is_pk,
    COALESCE((columns.character_maximum_length)::integer, (columns.numeric_precision)::integer, '-1'::integer) AS length,
    columns.numeric_scale AS scale,
        CASE columns.is_nullable
            WHEN 'NO'::text THEN 0
            ELSE 1
        END AS cannull,
    columns.column_default AS defaultval,
        CASE
            WHEN ("position"((columns.column_default)::text, 'nextval'::text) > 0) THEN 1
            ELSE 0
        END AS isidentity,
        CASE
            WHEN ("position"((columns.column_default)::text, 'nextval'::text) > 0) THEN 1
            ELSE 0
        END AS is_increment,
    c.detext AS column_comment,
    c.typname AS column_type,
    c.contype,
    columns.ordinal_position
   FROM (information_schema.columns
     LEFT JOIN ( SELECT pg_database.datname,
            pg_get_userbyid(pg_class.relowner) AS tableowner,
            pg_ns.nspname,
            pg_class.relname,
            pg_attr.attname,
            pg_desc.description AS detext,
            pg_type.typname,
            pg_cons.contype
           FROM ((((((pg_class
             LEFT JOIN pg_attribute pg_attr ON ((pg_attr.attrelid = pg_class.oid)))
             LEFT JOIN pg_description pg_desc ON (((pg_desc.objoid = pg_attr.attrelid) AND (pg_desc.objsubid = pg_attr.attnum))))
             LEFT JOIN pg_namespace pg_ns ON ((pg_ns.oid = pg_class.relnamespace)))
             LEFT JOIN pg_database ON ((pg_class.relowner = pg_database.datdba)))
             LEFT JOIN pg_type ON ((pg_attr.atttypid = pg_type.oid)))
             LEFT JOIN ( SELECT pg_con.oid,
                    pg_con.conname,
                    pg_con.connamespace,
                    pg_con.contype,
                    pg_con.condeferrable,
                    pg_con.condeferred,
                    pg_con.convalidated,
                    pg_con.conenabled,
                    pg_con.conrelid,
                    pg_con.contypid,
                    pg_con.conindid,
                    pg_con.conparentid,
                    pg_con.confrelid,
                    pg_con.confupdtype,
                    pg_con.confdeltype,
                    pg_con.confmatchtype,
                    pg_con.conislocal,
                    pg_con.coninhcount,
                    pg_con.connoinherit,
                    pg_con.conkey,
                    pg_con.confkey,
                    pg_con.conpfeqop,
                    pg_con.conppeqop,
                    pg_con.conffeqop,
                    pg_con.conexclop,
                    pg_con.conbin,
                    unnest(pg_con.conkey) AS conkey_new
                   FROM pg_constraint pg_con) pg_cons ON (((pg_attr.attrelid = pg_class.oid) AND (pg_attr.attnum = pg_cons.conkey_new) AND (pg_cons.conrelid = pg_class.oid))))
          WHERE ((pg_attr.attnum > 0) AND (pg_attr.attrelid = pg_class.oid))) c ON ((((columns.table_catalog)::name = c.datname) AND ((columns.table_schema)::name = c.nspname) AND ((columns.table_name)::name = c.relname) AND ((columns.column_name)::name = c.attname))));


ALTER TABLE ruoyi2.list_column OWNER TO sysdba;

--
-- TOC entry 287 (class 1259 OID 16470)
-- Name: list_table; Type: VIEW; Schema: ruoyi2; Owner: sysdba
--

CREATE VIEW ruoyi2.list_table AS
 SELECT c.relname AS table_name,
    obj_description(c.oid) AS table_comment,
    CURRENT_TIMESTAMP AS create_time,
    CURRENT_TIMESTAMP AS update_time
   FROM (pg_class c
     LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace)))
  WHERE ((c.relkind = ANY (ARRAY['r'::"char", 'p'::"char"])) AND (c.relname !~~ 'spatial_%'::text) AND (n.nspname = CURRENT_SCHEMA) AND (n.nspname <> ''::name));


ALTER TABLE ruoyi2.list_table OWNER TO sysdba;

--
-- TOC entry 288 (class 1259 OID 16475)
-- Name: qrtz_blob_triggers; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_blob_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    blob_data bytea
);


ALTER TABLE ruoyi2.qrtz_blob_triggers OWNER TO ruoyi;

--
-- TOC entry 7163 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN qrtz_blob_triggers.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_blob_triggers.sched_name IS '调度名称';


--
-- TOC entry 7164 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN qrtz_blob_triggers.trigger_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_blob_triggers.trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- TOC entry 7165 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN qrtz_blob_triggers.trigger_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_blob_triggers.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 7166 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN qrtz_blob_triggers.blob_data; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_blob_triggers.blob_data IS '存放持久化Trigger对象';


--
-- TOC entry 289 (class 1259 OID 16481)
-- Name: qrtz_calendars; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_calendars (
    sched_name character varying(120) NOT NULL,
    calendar_name character varying(200) NOT NULL,
    calendar bytea NOT NULL
);


ALTER TABLE ruoyi2.qrtz_calendars OWNER TO ruoyi;

--
-- TOC entry 7167 (class 0 OID 0)
-- Dependencies: 289
-- Name: COLUMN qrtz_calendars.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_calendars.sched_name IS '调度名称';


--
-- TOC entry 7168 (class 0 OID 0)
-- Dependencies: 289
-- Name: COLUMN qrtz_calendars.calendar_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_calendars.calendar_name IS '日历名称';


--
-- TOC entry 7169 (class 0 OID 0)
-- Dependencies: 289
-- Name: COLUMN qrtz_calendars.calendar; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_calendars.calendar IS '存放持久化calendar对象';


--
-- TOC entry 290 (class 1259 OID 16487)
-- Name: qrtz_cron_triggers; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_cron_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    cron_expression character varying(200) NOT NULL,
    time_zone_id character varying(80)
);


ALTER TABLE ruoyi2.qrtz_cron_triggers OWNER TO ruoyi;

--
-- TOC entry 7170 (class 0 OID 0)
-- Dependencies: 290
-- Name: COLUMN qrtz_cron_triggers.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_cron_triggers.sched_name IS '调度名称';


--
-- TOC entry 7171 (class 0 OID 0)
-- Dependencies: 290
-- Name: COLUMN qrtz_cron_triggers.trigger_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_cron_triggers.trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- TOC entry 7172 (class 0 OID 0)
-- Dependencies: 290
-- Name: COLUMN qrtz_cron_triggers.trigger_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_cron_triggers.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 7173 (class 0 OID 0)
-- Dependencies: 290
-- Name: COLUMN qrtz_cron_triggers.cron_expression; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_cron_triggers.cron_expression IS 'cron表达式';


--
-- TOC entry 7174 (class 0 OID 0)
-- Dependencies: 290
-- Name: COLUMN qrtz_cron_triggers.time_zone_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_cron_triggers.time_zone_id IS '时区';


--
-- TOC entry 291 (class 1259 OID 16493)
-- Name: qrtz_fired_triggers; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_fired_triggers (
    sched_name character varying(120) NOT NULL,
    entry_id character varying(95) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    instance_name character varying(200) NOT NULL,
    fired_time bigint NOT NULL,
    sched_time bigint NOT NULL,
    priority integer NOT NULL,
    state character varying(16) NOT NULL,
    job_name character varying(200),
    job_group character varying(200),
    is_nonconcurrent character varying(1),
    requests_recovery character varying(1)
);


ALTER TABLE ruoyi2.qrtz_fired_triggers OWNER TO ruoyi;

--
-- TOC entry 7175 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.sched_name IS '调度名称';


--
-- TOC entry 7176 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.entry_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.entry_id IS '调度器实例id';


--
-- TOC entry 7177 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.trigger_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- TOC entry 7178 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.trigger_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 7179 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.instance_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.instance_name IS '调度器实例名';


--
-- TOC entry 7180 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.fired_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.fired_time IS '触发的时间';


--
-- TOC entry 7181 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.sched_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.sched_time IS '定时器制定的时间';


--
-- TOC entry 7182 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.priority; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.priority IS '优先级';


--
-- TOC entry 7183 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.state; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.state IS '状态';


--
-- TOC entry 7184 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.job_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.job_name IS '任务名称';


--
-- TOC entry 7185 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.job_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.job_group IS '任务组名';


--
-- TOC entry 7186 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.is_nonconcurrent; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.is_nonconcurrent IS '是否并发';


--
-- TOC entry 7187 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN qrtz_fired_triggers.requests_recovery; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_fired_triggers.requests_recovery IS '是否接受恢复执行';


--
-- TOC entry 292 (class 1259 OID 16499)
-- Name: qrtz_job_details; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_job_details (
    sched_name character varying(120) NOT NULL,
    job_name character varying(200) NOT NULL,
    job_group character varying(200) NOT NULL,
    description character varying(250),
    job_class_name character varying(250) NOT NULL,
    is_durable character varying(1) NOT NULL,
    is_nonconcurrent character varying(1) NOT NULL,
    is_update_data character varying(1) NOT NULL,
    requests_recovery character varying(1) NOT NULL,
    job_data bytea
);


ALTER TABLE ruoyi2.qrtz_job_details OWNER TO ruoyi;

--
-- TOC entry 7188 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN qrtz_job_details.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_job_details.sched_name IS '调度名称';


--
-- TOC entry 7189 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN qrtz_job_details.job_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_job_details.job_name IS '任务名称';


--
-- TOC entry 7190 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN qrtz_job_details.job_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_job_details.job_group IS '任务组名';


--
-- TOC entry 7191 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN qrtz_job_details.description; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_job_details.description IS '相关介绍';


--
-- TOC entry 7192 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN qrtz_job_details.job_class_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_job_details.job_class_name IS '执行任务类名称';


--
-- TOC entry 7193 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN qrtz_job_details.is_durable; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_job_details.is_durable IS '是否持久化';


--
-- TOC entry 7194 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN qrtz_job_details.is_nonconcurrent; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_job_details.is_nonconcurrent IS '是否并发';


--
-- TOC entry 7195 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN qrtz_job_details.is_update_data; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_job_details.is_update_data IS '是否更新数据';


--
-- TOC entry 7196 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN qrtz_job_details.requests_recovery; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_job_details.requests_recovery IS '是否接受恢复执行';


--
-- TOC entry 7197 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN qrtz_job_details.job_data; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_job_details.job_data IS '存放持久化job对象';


--
-- TOC entry 293 (class 1259 OID 16505)
-- Name: qrtz_locks; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_locks (
    sched_name character varying(120) NOT NULL,
    lock_name character varying(40) NOT NULL
);


ALTER TABLE ruoyi2.qrtz_locks OWNER TO ruoyi;

--
-- TOC entry 7198 (class 0 OID 0)
-- Dependencies: 293
-- Name: COLUMN qrtz_locks.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_locks.sched_name IS '调度名称';


--
-- TOC entry 7199 (class 0 OID 0)
-- Dependencies: 293
-- Name: COLUMN qrtz_locks.lock_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_locks.lock_name IS '悲观锁名称';


--
-- TOC entry 294 (class 1259 OID 16508)
-- Name: qrtz_paused_trigger_grps; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_paused_trigger_grps (
    sched_name character varying(120) NOT NULL,
    trigger_group character varying(200) NOT NULL
);


ALTER TABLE ruoyi2.qrtz_paused_trigger_grps OWNER TO ruoyi;

--
-- TOC entry 7200 (class 0 OID 0)
-- Dependencies: 294
-- Name: COLUMN qrtz_paused_trigger_grps.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_paused_trigger_grps.sched_name IS '调度名称';


--
-- TOC entry 7201 (class 0 OID 0)
-- Dependencies: 294
-- Name: COLUMN qrtz_paused_trigger_grps.trigger_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_paused_trigger_grps.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 295 (class 1259 OID 16511)
-- Name: qrtz_scheduler_state; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_scheduler_state (
    sched_name character varying(120) NOT NULL,
    instance_name character varying(200) NOT NULL,
    last_checkin_time bigint NOT NULL,
    checkin_interval bigint NOT NULL
);


ALTER TABLE ruoyi2.qrtz_scheduler_state OWNER TO ruoyi;

--
-- TOC entry 7202 (class 0 OID 0)
-- Dependencies: 295
-- Name: COLUMN qrtz_scheduler_state.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_scheduler_state.sched_name IS '调度名称';


--
-- TOC entry 7203 (class 0 OID 0)
-- Dependencies: 295
-- Name: COLUMN qrtz_scheduler_state.instance_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_scheduler_state.instance_name IS '实例名称';


--
-- TOC entry 7204 (class 0 OID 0)
-- Dependencies: 295
-- Name: COLUMN qrtz_scheduler_state.last_checkin_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_scheduler_state.last_checkin_time IS '上次检查时间';


--
-- TOC entry 7205 (class 0 OID 0)
-- Dependencies: 295
-- Name: COLUMN qrtz_scheduler_state.checkin_interval; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_scheduler_state.checkin_interval IS '检查间隔时间';


--
-- TOC entry 296 (class 1259 OID 16514)
-- Name: qrtz_simple_triggers; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_simple_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    repeat_count bigint NOT NULL,
    repeat_interval bigint NOT NULL,
    times_triggered bigint NOT NULL
);


ALTER TABLE ruoyi2.qrtz_simple_triggers OWNER TO ruoyi;

--
-- TOC entry 7206 (class 0 OID 0)
-- Dependencies: 296
-- Name: COLUMN qrtz_simple_triggers.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simple_triggers.sched_name IS '调度名称';


--
-- TOC entry 7207 (class 0 OID 0)
-- Dependencies: 296
-- Name: COLUMN qrtz_simple_triggers.trigger_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simple_triggers.trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- TOC entry 7208 (class 0 OID 0)
-- Dependencies: 296
-- Name: COLUMN qrtz_simple_triggers.trigger_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simple_triggers.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 7209 (class 0 OID 0)
-- Dependencies: 296
-- Name: COLUMN qrtz_simple_triggers.repeat_count; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simple_triggers.repeat_count IS '重复的次数统计';


--
-- TOC entry 7210 (class 0 OID 0)
-- Dependencies: 296
-- Name: COLUMN qrtz_simple_triggers.repeat_interval; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simple_triggers.repeat_interval IS '重复的间隔时间';


--
-- TOC entry 7211 (class 0 OID 0)
-- Dependencies: 296
-- Name: COLUMN qrtz_simple_triggers.times_triggered; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simple_triggers.times_triggered IS '已经触发的次数';


--
-- TOC entry 297 (class 1259 OID 16520)
-- Name: qrtz_simprop_triggers; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_simprop_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    str_prop_1 character varying(512),
    str_prop_2 character varying(512),
    str_prop_3 character varying(512),
    int_prop_1 integer,
    int_prop_2 integer,
    long_prop_1 bigint,
    long_prop_2 bigint,
    dec_prop_1 numeric(13,4),
    dec_prop_2 numeric(13,4),
    bool_prop_1 character varying(1),
    bool_prop_2 character varying(1)
);


ALTER TABLE ruoyi2.qrtz_simprop_triggers OWNER TO ruoyi;

--
-- TOC entry 7212 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.sched_name IS '调度名称';


--
-- TOC entry 7213 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.trigger_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- TOC entry 7214 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.trigger_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 7215 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.str_prop_1; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.str_prop_1 IS 'String类型的trigger的第一个参数';


--
-- TOC entry 7216 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.str_prop_2; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.str_prop_2 IS 'String类型的trigger的第二个参数';


--
-- TOC entry 7217 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.str_prop_3; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.str_prop_3 IS 'String类型的trigger的第三个参数';


--
-- TOC entry 7218 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.int_prop_1; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.int_prop_1 IS 'int类型的trigger的第一个参数';


--
-- TOC entry 7219 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.int_prop_2; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.int_prop_2 IS 'int类型的trigger的第二个参数';


--
-- TOC entry 7220 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.long_prop_1; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.long_prop_1 IS 'long类型的trigger的第一个参数';


--
-- TOC entry 7221 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.long_prop_2; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.long_prop_2 IS 'long类型的trigger的第二个参数';


--
-- TOC entry 7222 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.dec_prop_1; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.dec_prop_1 IS 'decimal类型的trigger的第一个参数';


--
-- TOC entry 7223 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.dec_prop_2; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.dec_prop_2 IS 'decimal类型的trigger的第二个参数';


--
-- TOC entry 7224 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.bool_prop_1; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.bool_prop_1 IS 'Boolean类型的trigger的第一个参数';


--
-- TOC entry 7225 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN qrtz_simprop_triggers.bool_prop_2; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_simprop_triggers.bool_prop_2 IS 'Boolean类型的trigger的第二个参数';


--
-- TOC entry 298 (class 1259 OID 16526)
-- Name: qrtz_triggers; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.qrtz_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    job_name character varying(200) NOT NULL,
    job_group character varying(200) NOT NULL,
    description character varying(250),
    next_fire_time bigint,
    prev_fire_time bigint,
    priority integer,
    trigger_state character varying(16) NOT NULL,
    trigger_type character varying(8) NOT NULL,
    start_time bigint NOT NULL,
    end_time bigint,
    calendar_name character varying(200),
    misfire_instr smallint,
    job_data bytea
);


ALTER TABLE ruoyi2.qrtz_triggers OWNER TO ruoyi;

--
-- TOC entry 7226 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.sched_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.sched_name IS '调度名称';


--
-- TOC entry 7227 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.trigger_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.trigger_name IS '触发器的名字';


--
-- TOC entry 7228 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.trigger_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.trigger_group IS '触发器所属组的名字';


--
-- TOC entry 7229 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.job_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.job_name IS 'qrtz_job_details表job_name的外键';


--
-- TOC entry 7230 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.job_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.job_group IS 'qrtz_job_details表job_group的外键';


--
-- TOC entry 7231 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.description; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.description IS '相关介绍';


--
-- TOC entry 7232 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.next_fire_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.next_fire_time IS '上一次触发时间（毫秒）';


--
-- TOC entry 7233 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.prev_fire_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.prev_fire_time IS '下一次触发时间（默认为-1表示不触发）';


--
-- TOC entry 7234 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.priority; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.priority IS '优先级';


--
-- TOC entry 7235 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.trigger_state; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.trigger_state IS '触发器状态';


--
-- TOC entry 7236 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.trigger_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.trigger_type IS '触发器的类型';


--
-- TOC entry 7237 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.start_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.start_time IS '开始时间';


--
-- TOC entry 7238 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.end_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.end_time IS '结束时间';


--
-- TOC entry 7239 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.calendar_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.calendar_name IS '日程表名称';


--
-- TOC entry 7240 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.misfire_instr; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.misfire_instr IS '补偿执行的策略';


--
-- TOC entry 7241 (class 0 OID 0)
-- Dependencies: 298
-- Name: COLUMN qrtz_triggers.job_data; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.qrtz_triggers.job_data IS '存放持久化job对象';


--
-- TOC entry 299 (class 1259 OID 16532)
-- Name: seq_sys_config_config_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_config_config_id
    START WITH 7
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_config_config_id OWNER TO sysdba;

--
-- TOC entry 300 (class 1259 OID 16534)
-- Name: seq_sys_dept_dept_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_dept_dept_id
    START WITH 110
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_dept_dept_id OWNER TO sysdba;

--
-- TOC entry 301 (class 1259 OID 16536)
-- Name: seq_sys_dict_data_dict_code; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_dict_data_dict_code
    START WITH 30
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_dict_data_dict_code OWNER TO sysdba;

--
-- TOC entry 302 (class 1259 OID 16538)
-- Name: seq_sys_dict_type_dict_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_dict_type_dict_id
    START WITH 11
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_dict_type_dict_id OWNER TO sysdba;

--
-- TOC entry 303 (class 1259 OID 16540)
-- Name: seq_sys_job_job_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_job_job_id
    START WITH 4
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_job_job_id OWNER TO sysdba;

--
-- TOC entry 304 (class 1259 OID 16542)
-- Name: seq_sys_job_log_job_log_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_job_log_job_log_id
    START WITH 1
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_job_log_job_log_id OWNER TO sysdba;

--
-- TOC entry 305 (class 1259 OID 16544)
-- Name: seq_sys_logininfor_info_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_logininfor_info_id
    START WITH 1
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_logininfor_info_id OWNER TO sysdba;

--
-- TOC entry 306 (class 1259 OID 16546)
-- Name: seq_sys_menu_menu_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_menu_menu_id
    START WITH 1061
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_menu_menu_id OWNER TO sysdba;

--
-- TOC entry 307 (class 1259 OID 16548)
-- Name: seq_sys_notice_notice_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_notice_notice_id
    START WITH 3
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_notice_notice_id OWNER TO sysdba;

--
-- TOC entry 308 (class 1259 OID 16550)
-- Name: seq_sys_oper_log_oper_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_oper_log_oper_id
    START WITH 1
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_oper_log_oper_id OWNER TO sysdba;

--
-- TOC entry 309 (class 1259 OID 16552)
-- Name: seq_sys_post_post_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_post_post_id
    START WITH 5
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_post_post_id OWNER TO sysdba;

--
-- TOC entry 310 (class 1259 OID 16554)
-- Name: seq_sys_role_role_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_role_role_id
    START WITH 3
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_role_role_id OWNER TO sysdba;

--
-- TOC entry 311 (class 1259 OID 16556)
-- Name: seq_sys_user_user_id; Type: SEQUENCE; Schema: ruoyi2; Owner: sysdba
--

CREATE SEQUENCE ruoyi2.seq_sys_user_user_id
    START WITH 3
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi2.seq_sys_user_user_id OWNER TO sysdba;

--
-- TOC entry 312 (class 1259 OID 16558)
-- Name: sys_config; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_config (
    config_id integer DEFAULT nextval('ruoyi2.seq_sys_config_config_id'::regclass) NOT NULL,
    config_name character varying(100) DEFAULT ''::character varying,
    config_key character varying(100) DEFAULT ''::character varying,
    config_value character varying(500) DEFAULT ''::character varying,
    config_type character(1) DEFAULT 'N'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi2.sys_config OWNER TO ruoyi;

--
-- TOC entry 7242 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN sys_config.config_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_config.config_id IS '参数主键';


--
-- TOC entry 7243 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN sys_config.config_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_config.config_name IS '参数名称';


--
-- TOC entry 7244 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN sys_config.config_key; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_config.config_key IS '参数键名';


--
-- TOC entry 7245 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN sys_config.config_value; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_config.config_value IS '参数键值';


--
-- TOC entry 7246 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN sys_config.config_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_config.config_type IS '系统内置（Y是 N否）';


--
-- TOC entry 7247 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN sys_config.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_config.create_by IS '创建者';


--
-- TOC entry 7248 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN sys_config.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_config.create_time IS '创建时间';


--
-- TOC entry 7249 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN sys_config.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_config.update_by IS '更新者';


--
-- TOC entry 7250 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN sys_config.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_config.update_time IS '更新时间';


--
-- TOC entry 7251 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN sys_config.remark; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_config.remark IS '备注';


--
-- TOC entry 313 (class 1259 OID 16571)
-- Name: sys_dept; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_dept (
    dept_id bigint DEFAULT nextval('ruoyi2.seq_sys_dept_dept_id'::regclass) NOT NULL,
    parent_id bigint DEFAULT '0'::bigint,
    ancestors character varying(50) DEFAULT ''::character varying,
    dept_name character varying(30) DEFAULT ''::character varying,
    order_num integer DEFAULT 0,
    leader character varying(20),
    phone character varying(11),
    email character varying(50),
    status character(1) DEFAULT '0'::bpchar,
    del_flag character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone
);


ALTER TABLE ruoyi2.sys_dept OWNER TO ruoyi;

--
-- TOC entry 7252 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.dept_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.dept_id IS '部门id';


--
-- TOC entry 7253 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.parent_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.parent_id IS '父部门id';


--
-- TOC entry 7254 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.ancestors; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.ancestors IS '祖级列表';


--
-- TOC entry 7255 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.dept_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.dept_name IS '部门名称';


--
-- TOC entry 7256 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.order_num; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.order_num IS '显示顺序';


--
-- TOC entry 7257 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.leader; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.leader IS '负责人';


--
-- TOC entry 7258 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.phone; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.phone IS '联系电话';


--
-- TOC entry 7259 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.email; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.email IS '邮箱';


--
-- TOC entry 7260 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.status IS '部门状态（0正常 1停用）';


--
-- TOC entry 7261 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.del_flag; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.del_flag IS '删除标志（0代表存在 2代表删除）';


--
-- TOC entry 7262 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.create_by IS '创建者';


--
-- TOC entry 7263 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.create_time IS '创建时间';


--
-- TOC entry 7264 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.update_by IS '更新者';


--
-- TOC entry 7265 (class 0 OID 0)
-- Dependencies: 313
-- Name: COLUMN sys_dept.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dept.update_time IS '更新时间';


--
-- TOC entry 314 (class 1259 OID 16583)
-- Name: sys_dict_data; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_dict_data (
    dict_code bigint DEFAULT nextval('ruoyi2.seq_sys_dict_data_dict_code'::regclass) NOT NULL,
    dict_sort integer DEFAULT 0,
    dict_label character varying(100) DEFAULT ''::character varying,
    dict_value character varying(100) DEFAULT ''::character varying,
    dict_type character varying(100) DEFAULT ''::character varying,
    css_class character varying(100),
    list_class character varying(100),
    is_default character(1) DEFAULT 'N'::bpchar,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi2.sys_dict_data OWNER TO ruoyi;

--
-- TOC entry 7266 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.dict_code; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.dict_code IS '字典编码';


--
-- TOC entry 7267 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.dict_sort; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.dict_sort IS '字典排序';


--
-- TOC entry 7268 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.dict_label; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.dict_label IS '字典标签';


--
-- TOC entry 7269 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.dict_value; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.dict_value IS '字典键值';


--
-- TOC entry 7270 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.dict_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.dict_type IS '字典类型';


--
-- TOC entry 7271 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.css_class; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.css_class IS '样式属性（其他样式扩展）';


--
-- TOC entry 7272 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.list_class; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.list_class IS '表格回显样式';


--
-- TOC entry 7273 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.is_default; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.is_default IS '是否默认（Y是 N否）';


--
-- TOC entry 7274 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.status IS '状态（0正常 1停用）';


--
-- TOC entry 7275 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.create_by IS '创建者';


--
-- TOC entry 7276 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.create_time IS '创建时间';


--
-- TOC entry 7277 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.update_by IS '更新者';


--
-- TOC entry 7278 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.update_time IS '更新时间';


--
-- TOC entry 7279 (class 0 OID 0)
-- Dependencies: 314
-- Name: COLUMN sys_dict_data.remark; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_data.remark IS '备注';


--
-- TOC entry 315 (class 1259 OID 16598)
-- Name: sys_dict_type; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_dict_type (
    dict_id bigint DEFAULT nextval('ruoyi2.seq_sys_dict_type_dict_id'::regclass) NOT NULL,
    dict_name character varying(100) DEFAULT ''::character varying,
    dict_type character varying(100) DEFAULT ''::character varying,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi2.sys_dict_type OWNER TO ruoyi;

--
-- TOC entry 7280 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN sys_dict_type.dict_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_type.dict_id IS '字典主键';


--
-- TOC entry 7281 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN sys_dict_type.dict_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_type.dict_name IS '字典名称';


--
-- TOC entry 7282 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN sys_dict_type.dict_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_type.dict_type IS '字典类型';


--
-- TOC entry 7283 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN sys_dict_type.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_type.status IS '状态（0正常 1停用）';


--
-- TOC entry 7284 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN sys_dict_type.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_type.create_by IS '创建者';


--
-- TOC entry 7285 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN sys_dict_type.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_type.create_time IS '创建时间';


--
-- TOC entry 7286 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN sys_dict_type.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_type.update_by IS '更新者';


--
-- TOC entry 7287 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN sys_dict_type.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_type.update_time IS '更新时间';


--
-- TOC entry 7288 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN sys_dict_type.remark; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_dict_type.remark IS '备注';


--
-- TOC entry 316 (class 1259 OID 16610)
-- Name: sys_job; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_job (
    job_id bigint DEFAULT nextval('ruoyi2.seq_sys_job_job_id'::regclass) NOT NULL,
    job_name character varying(64) DEFAULT ''::character varying NOT NULL,
    job_group character varying(64) DEFAULT 'DEFAULT'::character varying NOT NULL,
    invoke_target character varying(500) NOT NULL,
    cron_expression character varying(255) DEFAULT ''::character varying,
    misfire_policy character varying(20) DEFAULT '3'::character varying,
    concurrent character(1) DEFAULT '1'::bpchar,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT ''::character varying
);


ALTER TABLE ruoyi2.sys_job OWNER TO ruoyi;

--
-- TOC entry 7289 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.job_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.job_id IS '任务ID';


--
-- TOC entry 7290 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.job_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.job_name IS '任务名称';


--
-- TOC entry 7291 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.job_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.job_group IS '任务组名';


--
-- TOC entry 7292 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.invoke_target; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.invoke_target IS '调用目标字符串';


--
-- TOC entry 7293 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.cron_expression; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.cron_expression IS 'cron执行表达式';


--
-- TOC entry 7294 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.misfire_policy; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.misfire_policy IS '计划执行错误策略（1立即执行 2执行一次 3放弃执行）';


--
-- TOC entry 7295 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.concurrent; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.concurrent IS '是否并发执行（0允许 1禁止）';


--
-- TOC entry 7296 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.status IS '状态（0正常 1暂停）';


--
-- TOC entry 7297 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.create_by IS '创建者';


--
-- TOC entry 7298 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.create_time IS '创建时间';


--
-- TOC entry 7299 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.update_by IS '更新者';


--
-- TOC entry 7300 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.update_time IS '更新时间';


--
-- TOC entry 7301 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN sys_job.remark; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job.remark IS '备注信息';


--
-- TOC entry 317 (class 1259 OID 16626)
-- Name: sys_job_log; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_job_log (
    job_log_id bigint DEFAULT nextval('ruoyi2.seq_sys_job_log_job_log_id'::regclass) NOT NULL,
    job_name character varying(64) NOT NULL,
    job_group character varying(64) NOT NULL,
    invoke_target character varying(500) NOT NULL,
    job_message character varying(500),
    status character(1) DEFAULT '0'::bpchar,
    exception_info character varying(2000) DEFAULT ''::character varying,
    create_time timestamp without time zone
);


ALTER TABLE ruoyi2.sys_job_log OWNER TO ruoyi;

--
-- TOC entry 7302 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN sys_job_log.job_log_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job_log.job_log_id IS '任务日志ID';


--
-- TOC entry 7303 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN sys_job_log.job_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job_log.job_name IS '任务名称';


--
-- TOC entry 7304 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN sys_job_log.job_group; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job_log.job_group IS '任务组名';


--
-- TOC entry 7305 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN sys_job_log.invoke_target; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job_log.invoke_target IS '调用目标字符串';


--
-- TOC entry 7306 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN sys_job_log.job_message; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job_log.job_message IS '日志信息';


--
-- TOC entry 7307 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN sys_job_log.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job_log.status IS '执行状态（0正常 1失败）';


--
-- TOC entry 7308 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN sys_job_log.exception_info; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job_log.exception_info IS '异常信息';


--
-- TOC entry 7309 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN sys_job_log.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_job_log.create_time IS '创建时间';


--
-- TOC entry 318 (class 1259 OID 16635)
-- Name: sys_logininfor; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_logininfor (
    info_id bigint DEFAULT nextval('ruoyi2.seq_sys_logininfor_info_id'::regclass) NOT NULL,
    user_name character varying(50) DEFAULT ''::character varying,
    ipaddr character varying(128) DEFAULT ''::character varying,
    login_location character varying(255) DEFAULT ''::character varying,
    browser character varying(50) DEFAULT ''::character varying,
    os character varying(50) DEFAULT ''::character varying,
    status character(1) DEFAULT '0'::bpchar,
    msg character varying(255) DEFAULT ''::character varying,
    login_time timestamp without time zone
);


ALTER TABLE ruoyi2.sys_logininfor OWNER TO ruoyi;

--
-- TOC entry 7310 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN sys_logininfor.info_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_logininfor.info_id IS '访问ID';


--
-- TOC entry 7311 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN sys_logininfor.user_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_logininfor.user_name IS '用户账号';


--
-- TOC entry 7312 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN sys_logininfor.ipaddr; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_logininfor.ipaddr IS '登录IP地址';


--
-- TOC entry 7313 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN sys_logininfor.login_location; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_logininfor.login_location IS '登录地点';


--
-- TOC entry 7314 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN sys_logininfor.browser; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_logininfor.browser IS '浏览器类型';


--
-- TOC entry 7315 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN sys_logininfor.os; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_logininfor.os IS '操作系统';


--
-- TOC entry 7316 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN sys_logininfor.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_logininfor.status IS '登录状态（0成功 1失败）';


--
-- TOC entry 7317 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN sys_logininfor.msg; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_logininfor.msg IS '提示消息';


--
-- TOC entry 7318 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN sys_logininfor.login_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_logininfor.login_time IS '访问时间';


--
-- TOC entry 319 (class 1259 OID 16649)
-- Name: sys_menu; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_menu (
    menu_id bigint DEFAULT nextval('ruoyi2.seq_sys_menu_menu_id'::regclass) NOT NULL,
    menu_name character varying(50) NOT NULL,
    parent_id bigint DEFAULT '0'::bigint,
    order_num integer DEFAULT 0,
    path character varying(200) DEFAULT ''::character varying,
    component character varying(255),
    query character varying(255),
    is_frame integer DEFAULT 1,
    is_cache integer DEFAULT 0,
    menu_type character(1) DEFAULT ''::bpchar,
    visible character(1) DEFAULT '0'::bpchar,
    status character(1) DEFAULT '0'::bpchar,
    perms character varying(100),
    icon character varying(100) DEFAULT '#'::character varying,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT ''::character varying
);


ALTER TABLE ruoyi2.sys_menu OWNER TO ruoyi;

--
-- TOC entry 7319 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.menu_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.menu_id IS '菜单ID';


--
-- TOC entry 7320 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.menu_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.menu_name IS '菜单名称';


--
-- TOC entry 7321 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.parent_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.parent_id IS '父菜单ID';


--
-- TOC entry 7322 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.order_num; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.order_num IS '显示顺序';


--
-- TOC entry 7323 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.path; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.path IS '路由地址';


--
-- TOC entry 7324 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.component; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.component IS '组件路径';


--
-- TOC entry 7325 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.query; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.query IS '路由参数';


--
-- TOC entry 7326 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.is_frame; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.is_frame IS '是否为外链（0是 1否）';


--
-- TOC entry 7327 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.is_cache; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.is_cache IS '是否缓存（0缓存 1不缓存）';


--
-- TOC entry 7328 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.menu_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.menu_type IS '菜单类型（M目录 C菜单 F按钮）';


--
-- TOC entry 7329 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.visible; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.visible IS '菜单状态（0显示 1隐藏）';


--
-- TOC entry 7330 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.status IS '菜单状态（0正常 1停用）';


--
-- TOC entry 7331 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.perms; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.perms IS '权限标识';


--
-- TOC entry 7332 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.icon; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.icon IS '菜单图标';


--
-- TOC entry 7333 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.create_by IS '创建者';


--
-- TOC entry 7334 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.create_time IS '创建时间';


--
-- TOC entry 7335 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.update_by IS '更新者';


--
-- TOC entry 7336 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.update_time IS '更新时间';


--
-- TOC entry 7337 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN sys_menu.remark; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_menu.remark IS '备注';


--
-- TOC entry 320 (class 1259 OID 16668)
-- Name: sys_notice; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_notice (
    notice_id integer DEFAULT nextval('ruoyi2.seq_sys_notice_notice_id'::regclass) NOT NULL,
    notice_title character varying(50) NOT NULL,
    notice_type character(1) NOT NULL,
    notice_content bytea,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(255)
);


ALTER TABLE ruoyi2.sys_notice OWNER TO ruoyi;

--
-- TOC entry 7338 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN sys_notice.notice_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_notice.notice_id IS '公告ID';


--
-- TOC entry 7339 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN sys_notice.notice_title; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_notice.notice_title IS '公告标题';


--
-- TOC entry 7340 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN sys_notice.notice_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_notice.notice_type IS '公告类型（1通知 2公告）';


--
-- TOC entry 7341 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN sys_notice.notice_content; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_notice.notice_content IS '公告内容';


--
-- TOC entry 7342 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN sys_notice.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_notice.status IS '公告状态（0正常 1关闭）';


--
-- TOC entry 7343 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN sys_notice.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_notice.create_by IS '创建者';


--
-- TOC entry 7344 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN sys_notice.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_notice.create_time IS '创建时间';


--
-- TOC entry 7345 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN sys_notice.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_notice.update_by IS '更新者';


--
-- TOC entry 7346 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN sys_notice.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_notice.update_time IS '更新时间';


--
-- TOC entry 7347 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN sys_notice.remark; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_notice.remark IS '备注';


--
-- TOC entry 321 (class 1259 OID 16678)
-- Name: sys_oper_log; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_oper_log (
    oper_id bigint DEFAULT nextval('ruoyi2.seq_sys_oper_log_oper_id'::regclass) NOT NULL,
    title character varying(50) DEFAULT ''::character varying,
    business_type integer DEFAULT 0,
    method character varying(100) DEFAULT ''::character varying,
    request_method character varying(10) DEFAULT ''::character varying,
    operator_type integer DEFAULT 0,
    oper_name character varying(50) DEFAULT ''::character varying,
    dept_name character varying(50) DEFAULT ''::character varying,
    oper_url character varying(255) DEFAULT ''::character varying,
    oper_ip character varying(128) DEFAULT ''::character varying,
    oper_location character varying(255) DEFAULT ''::character varying,
    oper_param character varying(2000) DEFAULT ''::character varying,
    json_result character varying(2000) DEFAULT ''::character varying,
    status integer DEFAULT 0,
    error_msg character varying(2000) DEFAULT ''::character varying,
    oper_time timestamp without time zone,
    cost_time bigint DEFAULT '0'::bigint
);


ALTER TABLE ruoyi2.sys_oper_log OWNER TO ruoyi;

--
-- TOC entry 7348 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.oper_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.oper_id IS '日志主键';


--
-- TOC entry 7349 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.title; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.title IS '模块标题';


--
-- TOC entry 7350 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.business_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.business_type IS '业务类型（0其它 1新增 2修改 3删除）';


--
-- TOC entry 7351 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.method; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.method IS '方法名称';


--
-- TOC entry 7352 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.request_method; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.request_method IS '请求方式';


--
-- TOC entry 7353 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.operator_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.operator_type IS '操作类别（0其它 1后台用户 2手机端用户）';


--
-- TOC entry 7354 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.oper_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.oper_name IS '操作人员';


--
-- TOC entry 7355 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.dept_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.dept_name IS '部门名称';


--
-- TOC entry 7356 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.oper_url; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.oper_url IS '请求URL';


--
-- TOC entry 7357 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.oper_ip; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.oper_ip IS '主机地址';


--
-- TOC entry 7358 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.oper_location; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.oper_location IS '操作地点';


--
-- TOC entry 7359 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.oper_param; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.oper_param IS '请求参数';


--
-- TOC entry 7360 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.json_result; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.json_result IS '返回参数';


--
-- TOC entry 7361 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.status IS '操作状态（0正常 1异常）';


--
-- TOC entry 7362 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.error_msg; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.error_msg IS '错误消息';


--
-- TOC entry 7363 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.oper_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.oper_time IS '操作时间';


--
-- TOC entry 7364 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN sys_oper_log.cost_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_oper_log.cost_time IS '消耗时间';


--
-- TOC entry 322 (class 1259 OID 16700)
-- Name: sys_post; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_post (
    post_id bigint DEFAULT nextval('ruoyi2.seq_sys_post_post_id'::regclass) NOT NULL,
    post_code character varying(64) NOT NULL,
    post_name character varying(50) NOT NULL,
    post_sort integer NOT NULL,
    status character(1) NOT NULL,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi2.sys_post OWNER TO ruoyi;

--
-- TOC entry 7365 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN sys_post.post_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_post.post_id IS '岗位ID';


--
-- TOC entry 7366 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN sys_post.post_code; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_post.post_code IS '岗位编码';


--
-- TOC entry 7367 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN sys_post.post_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_post.post_name IS '岗位名称';


--
-- TOC entry 7368 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN sys_post.post_sort; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_post.post_sort IS '显示顺序';


--
-- TOC entry 7369 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN sys_post.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_post.status IS '状态（0正常 1停用）';


--
-- TOC entry 7370 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN sys_post.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_post.create_by IS '创建者';


--
-- TOC entry 7371 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN sys_post.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_post.create_time IS '创建时间';


--
-- TOC entry 7372 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN sys_post.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_post.update_by IS '更新者';


--
-- TOC entry 7373 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN sys_post.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_post.update_time IS '更新时间';


--
-- TOC entry 7374 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN sys_post.remark; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_post.remark IS '备注';


--
-- TOC entry 323 (class 1259 OID 16709)
-- Name: sys_role; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_role (
    role_id bigint DEFAULT nextval('ruoyi2.seq_sys_role_role_id'::regclass) NOT NULL,
    role_name character varying(30) NOT NULL,
    role_key character varying(100) NOT NULL,
    role_sort integer NOT NULL,
    data_scope character(1) DEFAULT '1'::bpchar,
    menu_check_strictly smallint DEFAULT '1'::smallint,
    dept_check_strictly smallint DEFAULT '1'::smallint,
    status character(1) NOT NULL,
    del_flag character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi2.sys_role OWNER TO ruoyi;

--
-- TOC entry 7375 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.role_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.role_id IS '角色ID';


--
-- TOC entry 7376 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.role_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.role_name IS '角色名称';


--
-- TOC entry 7377 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.role_key; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.role_key IS '角色权限字符串';


--
-- TOC entry 7378 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.role_sort; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.role_sort IS '显示顺序';


--
-- TOC entry 7379 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.data_scope; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.data_scope IS '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）';


--
-- TOC entry 7380 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.menu_check_strictly; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.menu_check_strictly IS '菜单树选择项是否关联显示';


--
-- TOC entry 7381 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.dept_check_strictly; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.dept_check_strictly IS '部门树选择项是否关联显示';


--
-- TOC entry 7382 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.status IS '角色状态（0正常 1停用）';


--
-- TOC entry 7383 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.del_flag; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.del_flag IS '删除标志（0代表存在 2代表删除）';


--
-- TOC entry 7384 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.create_by IS '创建者';


--
-- TOC entry 7385 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.create_time IS '创建时间';


--
-- TOC entry 7386 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.update_by IS '更新者';


--
-- TOC entry 7387 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.update_time IS '更新时间';


--
-- TOC entry 7388 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN sys_role.remark; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role.remark IS '备注';


--
-- TOC entry 324 (class 1259 OID 16722)
-- Name: sys_role_dept; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_role_dept (
    role_id bigint NOT NULL,
    dept_id bigint NOT NULL
);


ALTER TABLE ruoyi2.sys_role_dept OWNER TO ruoyi;

--
-- TOC entry 7389 (class 0 OID 0)
-- Dependencies: 324
-- Name: COLUMN sys_role_dept.role_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role_dept.role_id IS '角色ID';


--
-- TOC entry 7390 (class 0 OID 0)
-- Dependencies: 324
-- Name: COLUMN sys_role_dept.dept_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role_dept.dept_id IS '部门ID';


--
-- TOC entry 325 (class 1259 OID 16725)
-- Name: sys_role_menu; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_role_menu (
    role_id bigint NOT NULL,
    menu_id bigint NOT NULL
);


ALTER TABLE ruoyi2.sys_role_menu OWNER TO ruoyi;

--
-- TOC entry 7391 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN sys_role_menu.role_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role_menu.role_id IS '角色ID';


--
-- TOC entry 7392 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN sys_role_menu.menu_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_role_menu.menu_id IS '菜单ID';


--
-- TOC entry 326 (class 1259 OID 16728)
-- Name: sys_user; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_user (
    user_id bigint DEFAULT nextval('ruoyi2.seq_sys_user_user_id'::regclass) NOT NULL,
    dept_id bigint,
    user_name character varying(30) NOT NULL,
    nick_name character varying(30) NOT NULL,
    user_type character varying(2) DEFAULT '00'::character varying,
    email character varying(50) DEFAULT ''::character varying,
    phonenumber character varying(11) DEFAULT ''::character varying,
    sex character(1) DEFAULT '0'::bpchar,
    avatar character varying(100) DEFAULT ''::character varying,
    password character varying(100) DEFAULT ''::character varying,
    status character(1) DEFAULT '0'::bpchar,
    del_flag character(1) DEFAULT '0'::bpchar,
    login_ip character varying(128) DEFAULT ''::character varying,
    login_date timestamp without time zone,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi2.sys_user OWNER TO ruoyi;

--
-- TOC entry 7393 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.user_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.user_id IS '用户ID';


--
-- TOC entry 7394 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.dept_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.dept_id IS '部门ID';


--
-- TOC entry 7395 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.user_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.user_name IS '用户账号';


--
-- TOC entry 7396 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.nick_name; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.nick_name IS '用户昵称';


--
-- TOC entry 7397 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.user_type; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.user_type IS '用户类型（00系统用户）';


--
-- TOC entry 7398 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.email; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.email IS '用户邮箱';


--
-- TOC entry 7399 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.phonenumber; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.phonenumber IS '手机号码';


--
-- TOC entry 7400 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.sex; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.sex IS '用户性别（0男 1女 2未知）';


--
-- TOC entry 7401 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.avatar; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.avatar IS '头像地址';


--
-- TOC entry 7402 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.password; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.password IS '密码';


--
-- TOC entry 7403 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.status; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.status IS '帐号状态（0正常 1停用）';


--
-- TOC entry 7404 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.del_flag; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.del_flag IS '删除标志（0代表存在 2代表删除）';


--
-- TOC entry 7405 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.login_ip; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.login_ip IS '最后登录IP';


--
-- TOC entry 7406 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.login_date; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.login_date IS '最后登录时间';


--
-- TOC entry 7407 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.create_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.create_by IS '创建者';


--
-- TOC entry 7408 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.create_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.create_time IS '创建时间';


--
-- TOC entry 7409 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.update_by; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.update_by IS '更新者';


--
-- TOC entry 7410 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.update_time; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.update_time IS '更新时间';


--
-- TOC entry 7411 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_user.remark; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user.remark IS '备注';


--
-- TOC entry 327 (class 1259 OID 16746)
-- Name: sys_user_post; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_user_post (
    user_id bigint NOT NULL,
    post_id bigint NOT NULL
);


ALTER TABLE ruoyi2.sys_user_post OWNER TO ruoyi;

--
-- TOC entry 7412 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN sys_user_post.user_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user_post.user_id IS '用户ID';


--
-- TOC entry 7413 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN sys_user_post.post_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user_post.post_id IS '岗位ID';


--
-- TOC entry 328 (class 1259 OID 16749)
-- Name: sys_user_role; Type: TABLE; Schema: ruoyi2; Owner: ruoyi
--

CREATE TABLE ruoyi2.sys_user_role (
    user_id bigint NOT NULL,
    role_id bigint NOT NULL
);


ALTER TABLE ruoyi2.sys_user_role OWNER TO ruoyi;

--
-- TOC entry 7414 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_user_role.user_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user_role.user_id IS '用户ID';


--
-- TOC entry 7415 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_user_role.role_id; Type: COMMENT; Schema: ruoyi2; Owner: ruoyi
--

COMMENT ON COLUMN ruoyi2.sys_user_role.role_id IS '角色ID';


--
-- TOC entry 525 (class 1259 OID 481257)
-- Name: test; Type: TABLE; Schema: ruoyi2; Owner: sysdba
--

CREATE TABLE ruoyi2.test (
    id integer
);


ALTER TABLE ruoyi2.test OWNER TO sysdba;

--
-- TOC entry 7071 (class 0 OID 16437)
-- Dependencies: 284
-- Data for Name: gen_table; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) FROM stdin;
3	part_2011		\N	\N	Part2011	crud	com.ruoyi.system	system	2011	\N	ruoyi	0	/	\N	admin	2023-09-18 13:55:46.01024		\N	\N
1	t1	测试表	\N	\N	T1	crud	com.ruoyi.system	system	t1	测试	ruoyi	0	/	{}	admin	2023-09-18 13:28:04.82863		2023-09-18 13:59:32.515376	\N
4	test		\N	\N	Test	crud	com.ruoyi.system	system	test	\N	ruoyi	0	/	\N	admin	2024-08-29 15:58:27.075551		\N	\N
5	sys_config		\N	\N	SysConfig	crud	com.ruoyi.system	system	config	\N	ruoyi	0	/	\N	admin	2024-08-29 15:58:47.563943		\N	\N
\.


--
-- TOC entry 7073 (class 0 OID 16454)
-- Dependencies: 286
-- Data for Name: gen_table_column; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_by, create_time, update_by, update_time) FROM stdin;
4	3	aaz351	\N	character varying	String	aaz351	1	0	0	1	\N	\N	\N	EQ	\N		1	admin	2023-09-18 13:55:46.01024		\N
5	3	aac001	\N	character varying	String	aac001	0	0	0	1	1	1	1	EQ	\N		2	admin	2023-09-18 13:55:46.01024		\N
6	3	bie011	\N	character varying	String	bie011	0	0	0	1	1	1	1	EQ	\N		3	admin	2023-09-18 13:55:46.01024		\N
7	3	aae149	\N	character varying	String	aae149	1	0	0	1	\N	\N	\N	EQ	\N		4	admin	2023-09-18 13:55:46.01024		\N
8	3	aae140	\N	character varying	String	aae140	0	0	0	1	1	1	1	EQ	\N		5	admin	2023-09-18 13:55:46.01024		\N
9	3	aaa036	\N	character varying	String	aaa036	0	0	0	1	1	1	1	EQ	\N		6	admin	2023-09-18 13:55:46.01024		\N
10	3	aae019	\N	numeric	String	aae019	0	0	0	1	1	1	1	EQ	\N		7	admin	2023-09-18 13:55:46.01024		\N
11	3	aae072	\N	character varying	String	aae072	0	0	0	1	1	1	1	EQ	\N		8	admin	2023-09-18 13:55:46.01024		\N
12	3	aae002	\N	character varying	String	aae002	0	0	0	1	1	1	1	EQ	\N		9	admin	2023-09-18 13:55:46.01024		\N
13	3	aae013	\N	character varying	String	aae013	0	0	0	1	1	1	1	EQ	\N		10	admin	2023-09-18 13:55:46.01024		\N
14	3	aae011	\N	character varying	String	aae011	0	0	0	1	1	1	1	EQ	\N		11	admin	2023-09-18 13:55:46.01024		\N
15	3	aae036	\N	timestamp without time zone	String	aae036	0	0	0	1	1	1	1	EQ	\N		12	admin	2023-09-18 13:55:46.01024		\N
16	3	bae013	\N	character varying	String	bae013	0	0	0	1	1	1	1	EQ	\N		13	admin	2023-09-18 13:55:46.01024		\N
17	3	aid001	\N	character varying	String	aid001	0	0	0	1	1	1	1	EQ	\N		14	admin	2023-09-18 13:55:46.01024		\N
18	3	cic003	\N	character varying	String	cic003	0	0	0	1	1	1	1	EQ	\N		15	admin	2023-09-18 13:55:46.01024		\N
19	3	cic008	\N	character varying	String	cic008	0	0	0	1	1	1	1	EQ	\N		16	admin	2023-09-18 13:55:46.01024		\N
20	3	cic009	\N	character varying	String	cic009	0	0	0	1	1	1	1	EQ	\N		17	admin	2023-09-18 13:55:46.01024		\N
21	3	aaz039	\N	character varying	String	aaz039	0	0	0	1	1	1	1	EQ	\N		18	admin	2023-09-18 13:55:46.01024		\N
22	3	cic010	\N	character varying	String	cic010	0	0	0	1	1	1	1	EQ	\N		19	admin	2023-09-18 13:55:46.01024		\N
23	3	aaz219	\N	numeric	String	aaz219	0	0	0	1	1	1	1	EQ	\N		20	admin	2023-09-18 13:55:46.01024		\N
1	1	id	序号	integer	Long	id	0	0	0	1	\N	\N	\N	EQ	input		1	admin	2023-09-18 13:28:04.82863		2023-09-18 13:59:32.515376
2	1	name	人员名称	character varying	String	name	0	0	0	1	1	1	1	LIKE	\N		2	admin	2023-09-18 13:28:04.82863		2023-09-18 13:59:32.515376
24	4	name	\N	varchar	String	name	0	0	\N	1	1	1	1	LIKE	input		1	admin	2024-08-29 15:58:27.075551		\N
25	4	id	\N	int4	String	id	1	0	\N	1	\N	\N	\N	EQ	\N		2	admin	2024-08-29 15:58:27.075551		\N
26	4	time	\N	timestamp	Date	time	0	0	\N	1	1	1	1	EQ	datetime		3	admin	2024-08-29 15:58:27.075551		\N
27	4	id	\N	int4	String	id	0	0	\N	1	\N	\N	\N	EQ	\N		1	admin	2024-08-29 15:58:27.075551		\N
28	4	id	\N	int4	String	id	0	0	\N	1	\N	\N	\N	EQ	\N		1	admin	2024-08-29 15:58:27.075551		\N
29	4	name0	\N	varchar	String	name0	0	0	\N	1	1	1	1	EQ	input		2	admin	2024-08-29 15:58:27.075551		\N
30	4	name1	\N	varchar	String	name1	0	0	\N	1	1	1	1	EQ	input		3	admin	2024-08-29 15:58:27.075551		\N
31	4	name2	\N	varchar	String	name2	0	0	\N	1	1	1	1	EQ	input		4	admin	2024-08-29 15:58:27.075551		\N
32	4	name3	\N	varchar	String	name3	0	0	\N	1	1	1	1	EQ	input		5	admin	2024-08-29 15:58:27.075551		\N
33	4	name4	\N	varchar	String	name4	0	0	\N	1	1	1	1	EQ	input		6	admin	2024-08-29 15:58:27.075551		\N
34	4	name5	\N	varchar	String	name5	0	0	\N	1	1	1	1	EQ	input		7	admin	2024-08-29 15:58:27.075551		\N
35	4	name6	\N	varchar	String	name6	0	0	\N	1	1	1	1	EQ	input		8	admin	2024-08-29 15:58:27.075551		\N
36	4	name7	\N	varchar	String	name7	0	0	\N	1	1	1	1	EQ	input		9	admin	2024-08-29 15:58:27.075551		\N
37	4	name8	\N	varchar	String	name8	0	0	\N	1	1	1	1	EQ	input		10	admin	2024-08-29 15:58:27.075551		\N
38	4	name9	\N	varchar	String	name9	0	0	\N	1	1	1	1	EQ	input		11	admin	2024-08-29 15:58:27.075551		\N
39	4	name10	\N	varchar	String	name10	0	0	\N	1	1	1	1	EQ	input		12	admin	2024-08-29 15:58:27.075551		\N
40	4	name11	\N	varchar	String	name11	0	0	\N	1	1	1	1	EQ	input		13	admin	2024-08-29 15:58:27.075551		\N
41	4	name12	\N	varchar	String	name12	0	0	\N	1	1	1	1	EQ	input		14	admin	2024-08-29 15:58:27.075551		\N
42	4	name13	\N	varchar	String	name13	0	0	\N	1	1	1	1	EQ	input		15	admin	2024-08-29 15:58:27.075551		\N
43	4	name14	\N	varchar	String	name14	0	0	\N	1	1	1	1	EQ	input		16	admin	2024-08-29 15:58:27.075551		\N
44	4	name15	\N	varchar	String	name15	0	0	\N	1	1	1	1	EQ	input		17	admin	2024-08-29 15:58:27.075551		\N
45	4	id	\N	int4	String	id	0	0	\N	1	\N	\N	\N	EQ	\N		1	admin	2024-08-29 15:58:27.075551		\N
46	5	config_id	\N	\N	String	configId	0	1	\N	1	1	1	1	EQ	\N		1	admin	2024-08-29 15:58:47.563943		\N
47	5	config_name	\N	\N	String	configName	0	0	\N	1	1	1	1	LIKE	\N		2	admin	2024-08-29 15:58:47.563943		\N
48	5	config_key	\N	\N	String	configKey	0	0	\N	1	1	1	1	EQ	\N		3	admin	2024-08-29 15:58:47.563943		\N
49	5	config_value	\N	\N	String	configValue	0	0	\N	1	1	1	1	EQ	\N		4	admin	2024-08-29 15:58:47.563943		\N
50	5	config_type	\N	\N	String	configType	0	0	\N	1	1	1	1	EQ	select		5	admin	2024-08-29 15:58:47.563943		\N
51	5	create_by	\N	\N	String	createBy	0	0	\N	1	\N	\N	\N	EQ	\N		6	admin	2024-08-29 15:58:47.563943		\N
52	5	create_time	\N	\N	String	createTime	0	0	\N	1	\N	\N	\N	EQ	\N		7	admin	2024-08-29 15:58:47.563943		\N
53	5	update_by	\N	\N	String	updateBy	0	0	\N	1	1	\N	\N	EQ	\N		8	admin	2024-08-29 15:58:47.563943		\N
54	5	update_time	\N	\N	String	updateTime	0	0	\N	1	1	\N	\N	EQ	\N		9	admin	2024-08-29 15:58:47.563943		\N
55	5	remark	\N	\N	String	remark	0	0	\N	1	1	1	\N	EQ	\N		10	admin	2024-08-29 15:58:47.563943		\N
56	5	config_id	参数主键	int8	String	configId	1	1	\N	1	\N	\N	\N	EQ	\N		1	admin	2024-08-29 15:58:47.563943		\N
57	5	config_name	参数名称	varchar	String	configName	0	0	\N	1	1	1	1	LIKE	input		2	admin	2024-08-29 15:58:47.563943		\N
58	5	config_key	参数键名	varchar	String	configKey	0	0	\N	1	1	1	1	EQ	input		3	admin	2024-08-29 15:58:47.563943		\N
59	5	config_value	参数键值	varchar	String	configValue	0	0	\N	1	1	1	1	EQ	input		4	admin	2024-08-29 15:58:47.563943		\N
60	5	config_type	系统内置（Y是 N否）	bpchar	String	configType	0	0	\N	1	1	1	1	EQ	select		5	admin	2024-08-29 15:58:47.563943		\N
61	5	create_by	创建者	varchar	String	createBy	0	0	\N	1	\N	\N	\N	EQ	input		6	admin	2024-08-29 15:58:47.563943		\N
62	5	create_time	创建时间	timestamp	Date	createTime	0	0	\N	1	\N	\N	\N	EQ	datetime		7	admin	2024-08-29 15:58:47.563943		\N
63	5	update_by	更新者	varchar	String	updateBy	0	0	\N	1	1	\N	\N	EQ	input		8	admin	2024-08-29 15:58:47.563943		\N
64	5	update_time	更新时间	timestamp	Date	updateTime	0	0	\N	1	1	\N	\N	EQ	datetime		9	admin	2024-08-29 15:58:47.563943		\N
65	5	remark	备注	varchar	String	remark	0	0	\N	1	1	1	\N	EQ	input		10	admin	2024-08-29 15:58:47.563943		\N
\.


--
-- TOC entry 7074 (class 0 OID 16475)
-- Dependencies: 288
-- Data for Name: qrtz_blob_triggers; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_blob_triggers (sched_name, trigger_name, trigger_group, blob_data) FROM stdin;
\.


--
-- TOC entry 7075 (class 0 OID 16481)
-- Dependencies: 289
-- Data for Name: qrtz_calendars; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_calendars (sched_name, calendar_name, calendar) FROM stdin;
\.


--
-- TOC entry 7076 (class 0 OID 16487)
-- Dependencies: 290
-- Data for Name: qrtz_cron_triggers; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_cron_triggers (sched_name, trigger_name, trigger_group, cron_expression, time_zone_id) FROM stdin;
\.


--
-- TOC entry 7077 (class 0 OID 16493)
-- Dependencies: 291
-- Data for Name: qrtz_fired_triggers; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_fired_triggers (sched_name, entry_id, trigger_name, trigger_group, instance_name, fired_time, sched_time, priority, state, job_name, job_group, is_nonconcurrent, requests_recovery) FROM stdin;
\.


--
-- TOC entry 7078 (class 0 OID 16499)
-- Dependencies: 292
-- Data for Name: qrtz_job_details; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_job_details (sched_name, job_name, job_group, description, job_class_name, is_durable, is_nonconcurrent, is_update_data, requests_recovery, job_data) FROM stdin;
\.


--
-- TOC entry 7079 (class 0 OID 16505)
-- Dependencies: 293
-- Data for Name: qrtz_locks; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_locks (sched_name, lock_name) FROM stdin;
\.


--
-- TOC entry 7080 (class 0 OID 16508)
-- Dependencies: 294
-- Data for Name: qrtz_paused_trigger_grps; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_paused_trigger_grps (sched_name, trigger_group) FROM stdin;
\.


--
-- TOC entry 7081 (class 0 OID 16511)
-- Dependencies: 295
-- Data for Name: qrtz_scheduler_state; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_scheduler_state (sched_name, instance_name, last_checkin_time, checkin_interval) FROM stdin;
\.


--
-- TOC entry 7082 (class 0 OID 16514)
-- Dependencies: 296
-- Data for Name: qrtz_simple_triggers; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_simple_triggers (sched_name, trigger_name, trigger_group, repeat_count, repeat_interval, times_triggered) FROM stdin;
\.


--
-- TOC entry 7083 (class 0 OID 16520)
-- Dependencies: 297
-- Data for Name: qrtz_simprop_triggers; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_simprop_triggers (sched_name, trigger_name, trigger_group, str_prop_1, str_prop_2, str_prop_3, int_prop_1, int_prop_2, long_prop_1, long_prop_2, dec_prop_1, dec_prop_2, bool_prop_1, bool_prop_2) FROM stdin;
\.


--
-- TOC entry 7084 (class 0 OID 16526)
-- Dependencies: 298
-- Data for Name: qrtz_triggers; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.qrtz_triggers (sched_name, trigger_name, trigger_group, job_name, job_group, description, next_fire_time, prev_fire_time, priority, trigger_state, trigger_type, start_time, end_time, calendar_name, misfire_instr, job_data) FROM stdin;
\.


--
-- TOC entry 7098 (class 0 OID 16558)
-- Dependencies: 312
-- Data for Name: sys_config; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	主框架页-默认皮肤样式名称	sys.index.skinName	skin-blue	Y	admin	2023-09-18 10:20:16		\N	蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow
2	用户管理-账号初始密码	sys.user.initPassword	123456	Y	admin	2023-09-18 10:20:16		\N	初始化密码 123456
3	主框架页-侧边栏主题	sys.index.sideTheme	theme-dark	Y	admin	2023-09-18 10:20:16		\N	深色主题theme-dark，浅色主题theme-light
4	账号自助-验证码开关	sys.account.captchaEnabled	true	Y	admin	2023-09-18 10:20:16		\N	是否开启验证码功能（true开启，false关闭）
5	账号自助-是否开启用户注册功能	sys.account.registerUser	false	Y	admin	2023-09-18 10:20:16		\N	是否开启注册用户功能（true开启，false关闭）
6	用户登录-黑名单列表	sys.login.blackIPList		Y	admin	2023-09-18 10:20:16		\N	设置登录IP黑名单限制，多个匹配项以;分隔，支持匹配（*通配、网段）
\.


--
-- TOC entry 7099 (class 0 OID 16571)
-- Dependencies: 313
-- Data for Name: sys_dept; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader, phone, email, status, del_flag, create_by, create_time, update_by, update_time) FROM stdin;
103	101	0,100,101	研发部门	1	若依	15888888888	ry@qq.com	0	0	admin	2023-09-18 10:20:15		\N
104	101	0,100,101	市场部门	2	若依	15888888888	ry@qq.com	0	0	admin	2023-09-18 10:20:15		\N
105	101	0,100,101	测试部门	3	若依	15888888888	ry@qq.com	0	0	admin	2023-09-18 10:20:15		\N
106	101	0,100,101	财务部门	4	若依	15888888888	ry@qq.com	0	0	admin	2023-09-18 10:20:15		\N
107	101	0,100,101	运维部门	5	若依	15888888888	ry@qq.com	0	0	admin	2023-09-18 10:20:15		\N
108	102	0,100,102	市场部门	1	若依	15888888888	ry@qq.com	0	0	admin	2023-09-18 10:20:15		\N
109	102	0,100,102	财务部门	2	若依	15888888888	ry@qq.com	0	0	admin	2023-09-18 10:20:15		\N
100	0	0	瀚高股份有限公司	0	若依	15888888888	ry@qq.com	0	0	admin	2023-09-18 10:20:15		\N
101	100	0,100	北京总公司	1	若依	15888888888	ry@qq.com	0	0	admin	2023-09-18 10:20:15		\N
102	100	0,100	济南分公司	2	若依	15888888888	ry@qq.com	0	0	admin	2023-09-18 10:20:15		\N
\.


--
-- TOC entry 7100 (class 0 OID 16583)
-- Dependencies: 314
-- Data for Name: sys_dict_data; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	1	男	0	sys_user_sex			Y	0	admin	2023-09-18 10:20:16		\N	性别男
2	2	女	1	sys_user_sex			N	0	admin	2023-09-18 10:20:16		\N	性别女
3	3	未知	2	sys_user_sex			N	0	admin	2023-09-18 10:20:16		\N	性别未知
4	1	显示	0	sys_show_hide		primary	Y	0	admin	2023-09-18 10:20:16		\N	显示菜单
5	2	隐藏	1	sys_show_hide		danger	N	0	admin	2023-09-18 10:20:16		\N	隐藏菜单
6	1	正常	0	sys_normal_disable		primary	Y	0	admin	2023-09-18 10:20:16		\N	正常状态
7	2	停用	1	sys_normal_disable		danger	N	0	admin	2023-09-18 10:20:16		\N	停用状态
8	1	正常	0	sys_job_status		primary	Y	0	admin	2023-09-18 10:20:16		\N	正常状态
9	2	暂停	1	sys_job_status		danger	N	0	admin	2023-09-18 10:20:16		\N	停用状态
10	1	默认	DEFAULT	sys_job_group			Y	0	admin	2023-09-18 10:20:16		\N	默认分组
11	2	系统	SYSTEM	sys_job_group			N	0	admin	2023-09-18 10:20:16		\N	系统分组
12	1	是	Y	sys_yes_no		primary	Y	0	admin	2023-09-18 10:20:16		\N	系统默认是
13	2	否	N	sys_yes_no		danger	N	0	admin	2023-09-18 10:20:16		\N	系统默认否
14	1	通知	1	sys_notice_type		warning	Y	0	admin	2023-09-18 10:20:16		\N	通知
15	2	公告	2	sys_notice_type		success	N	0	admin	2023-09-18 10:20:16		\N	公告
16	1	正常	0	sys_notice_status		primary	Y	0	admin	2023-09-18 10:20:16		\N	正常状态
17	2	关闭	1	sys_notice_status		danger	N	0	admin	2023-09-18 10:20:16		\N	关闭状态
18	99	其他	0	sys_oper_type		info	N	0	admin	2023-09-18 10:20:16		\N	其他操作
19	1	新增	1	sys_oper_type		info	N	0	admin	2023-09-18 10:20:16		\N	新增操作
20	2	修改	2	sys_oper_type		info	N	0	admin	2023-09-18 10:20:16		\N	修改操作
21	3	删除	3	sys_oper_type		danger	N	0	admin	2023-09-18 10:20:16		\N	删除操作
22	4	授权	4	sys_oper_type		primary	N	0	admin	2023-09-18 10:20:16		\N	授权操作
23	5	导出	5	sys_oper_type		warning	N	0	admin	2023-09-18 10:20:16		\N	导出操作
24	6	导入	6	sys_oper_type		warning	N	0	admin	2023-09-18 10:20:16		\N	导入操作
25	7	强退	7	sys_oper_type		danger	N	0	admin	2023-09-18 10:20:16		\N	强退操作
26	8	生成代码	8	sys_oper_type		warning	N	0	admin	2023-09-18 10:20:16		\N	生成操作
27	9	清空数据	9	sys_oper_type		danger	N	0	admin	2023-09-18 10:20:16		\N	清空操作
28	1	成功	0	sys_common_status		primary	N	0	admin	2023-09-18 10:20:16		\N	正常状态
29	2	失败	1	sys_common_status		danger	N	0	admin	2023-09-18 10:20:16		\N	停用状态
\.


--
-- TOC entry 7101 (class 0 OID 16598)
-- Dependencies: 315
-- Data for Name: sys_dict_type; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	用户性别	sys_user_sex	0	admin	2023-09-18 10:20:16		\N	用户性别列表
2	菜单状态	sys_show_hide	0	admin	2023-09-18 10:20:16		\N	菜单状态列表
3	系统开关	sys_normal_disable	0	admin	2023-09-18 10:20:16		\N	系统开关列表
4	任务状态	sys_job_status	0	admin	2023-09-18 10:20:16		\N	任务状态列表
5	任务分组	sys_job_group	0	admin	2023-09-18 10:20:16		\N	任务分组列表
6	系统是否	sys_yes_no	0	admin	2023-09-18 10:20:16		\N	系统是否列表
7	通知类型	sys_notice_type	0	admin	2023-09-18 10:20:16		\N	通知类型列表
8	通知状态	sys_notice_status	0	admin	2023-09-18 10:20:16		\N	通知状态列表
9	操作类型	sys_oper_type	0	admin	2023-09-18 10:20:16		\N	操作类型列表
10	系统状态	sys_common_status	0	admin	2023-09-18 10:20:16		\N	登录状态列表
\.


--
-- TOC entry 7102 (class 0 OID 16610)
-- Dependencies: 316
-- Data for Name: sys_job; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	系统默认（无参）	DEFAULT	ryTask.ryNoParams	0/10 * * * * ?	3	1	1	admin	2023-09-18 10:20:16		\N	
3	系统默认（多参）	DEFAULT	ryTask.ryMultipleParams('ry', true, 2000L, 316.50D, 100)	0/20 * * * * ?	3	1	1	admin	2023-09-18 10:20:16		\N	
2	系统默认（有参）	DEFAULT	ryTask.ryParams('ry')	0/15 * * * * ?	3	1	1	admin	2023-09-18 10:20:16		2023-09-18 13:29:09.859828	
\.


--
-- TOC entry 7103 (class 0 OID 16626)
-- Dependencies: 317
-- Data for Name: sys_job_log; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_job_log (job_log_id, job_name, job_group, invoke_target, job_message, status, exception_info, create_time) FROM stdin;
\.


--
-- TOC entry 7104 (class 0 OID 16635)
-- Dependencies: 318
-- Data for Name: sys_logininfor; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_logininfor (info_id, user_name, ipaddr, login_location, browser, os, status, msg, login_time) FROM stdin;
1	admin	127.0.0.1	内网IP	Chrome 11	Windows 10	0	登录成功	2023-09-18 13:12:03.253834
2	admin	192.168.52.1	内网IP	Chrome 11	Windows 10	0	登录成功	2023-09-18 13:13:26.318944
3	admin	127.0.0.1	内网IP	Chrome 12	Windows 10	0	登录成功	2024-08-29 15:32:50.769346
\.


--
-- TOC entry 7105 (class 0 OID 16649)
-- Dependencies: 319
-- Data for Name: sys_menu; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	系统管理	0	1	system	\N		1	0	M	0	0		system	admin	2023-09-18 10:20:15		\N	系统管理目录
2	系统监控	0	2	monitor	\N		1	0	M	0	0		monitor	admin	2023-09-18 10:20:15		\N	系统监控目录
3	系统工具	0	3	tool	\N		1	0	M	0	0		tool	admin	2023-09-18 10:20:15		\N	系统工具目录
4	若依官网	0	4	http://ruoyi.vip	\N		0	0	M	0	0		guide	admin	2023-09-18 10:20:15		\N	若依官网地址
100	用户管理	1	1	user	system/user/index		1	0	C	0	0	system:user:list	user	admin	2023-09-18 10:20:15		\N	用户管理菜单
101	角色管理	1	2	role	system/role/index		1	0	C	0	0	system:role:list	peoples	admin	2023-09-18 10:20:15		\N	角色管理菜单
102	菜单管理	1	3	menu	system/menu/index		1	0	C	0	0	system:menu:list	tree-table	admin	2023-09-18 10:20:15		\N	菜单管理菜单
103	部门管理	1	4	dept	system/dept/index		1	0	C	0	0	system:dept:list	tree	admin	2023-09-18 10:20:15		\N	部门管理菜单
104	岗位管理	1	5	post	system/post/index		1	0	C	0	0	system:post:list	post	admin	2023-09-18 10:20:15		\N	岗位管理菜单
105	字典管理	1	6	dict	system/dict/index		1	0	C	0	0	system:dict:list	dict	admin	2023-09-18 10:20:15		\N	字典管理菜单
106	参数设置	1	7	config	system/config/index		1	0	C	0	0	system:config:list	edit	admin	2023-09-18 10:20:15		\N	参数设置菜单
107	通知公告	1	8	notice	system/notice/index		1	0	C	0	0	system:notice:list	message	admin	2023-09-18 10:20:15		\N	通知公告菜单
108	日志管理	1	9	log			1	0	M	0	0		log	admin	2023-09-18 10:20:15		\N	日志管理菜单
109	在线用户	2	1	online	monitor/online/index		1	0	C	0	0	monitor:online:list	online	admin	2023-09-18 10:20:15		\N	在线用户菜单
110	定时任务	2	2	job	monitor/job/index		1	0	C	0	0	monitor:job:list	job	admin	2023-09-18 10:20:15		\N	定时任务菜单
111	数据监控	2	3	druid	monitor/druid/index		1	0	C	0	0	monitor:druid:list	druid	admin	2023-09-18 10:20:15		\N	数据监控菜单
112	服务监控	2	4	server	monitor/server/index		1	0	C	0	0	monitor:server:list	server	admin	2023-09-18 10:20:15		\N	服务监控菜单
113	缓存监控	2	5	cache	monitor/cache/index		1	0	C	0	0	monitor:cache:list	redis	admin	2023-09-18 10:20:15		\N	缓存监控菜单
114	缓存列表	2	6	cacheList	monitor/cache/list		1	0	C	0	0	monitor:cache:list	redis-list	admin	2023-09-18 10:20:15		\N	缓存列表菜单
115	表单构建	3	1	build	tool/build/index		1	0	C	0	0	tool:build:list	build	admin	2023-09-18 10:20:15		\N	表单构建菜单
116	代码生成	3	2	gen	tool/gen/index		1	0	C	0	0	tool:gen:list	code	admin	2023-09-18 10:20:15		\N	代码生成菜单
117	系统接口	3	3	swagger	tool/swagger/index		1	0	C	0	0	tool:swagger:list	swagger	admin	2023-09-18 10:20:15		\N	系统接口菜单
500	操作日志	108	1	operlog	monitor/operlog/index		1	0	C	0	0	monitor:operlog:list	form	admin	2023-09-18 10:20:15		\N	操作日志菜单
501	登录日志	108	2	logininfor	monitor/logininfor/index		1	0	C	0	0	monitor:logininfor:list	logininfor	admin	2023-09-18 10:20:15		\N	登录日志菜单
1000	用户查询	100	1				1	0	F	0	0	system:user:query	#	admin	2023-09-18 10:20:15		\N	
1001	用户新增	100	2				1	0	F	0	0	system:user:add	#	admin	2023-09-18 10:20:15		\N	
1002	用户修改	100	3				1	0	F	0	0	system:user:edit	#	admin	2023-09-18 10:20:15		\N	
1003	用户删除	100	4				1	0	F	0	0	system:user:remove	#	admin	2023-09-18 10:20:15		\N	
1004	用户导出	100	5				1	0	F	0	0	system:user:export	#	admin	2023-09-18 10:20:15		\N	
1005	用户导入	100	6				1	0	F	0	0	system:user:import	#	admin	2023-09-18 10:20:15		\N	
1006	重置密码	100	7				1	0	F	0	0	system:user:resetPwd	#	admin	2023-09-18 10:20:15		\N	
1007	角色查询	101	1				1	0	F	0	0	system:role:query	#	admin	2023-09-18 10:20:15		\N	
1008	角色新增	101	2				1	0	F	0	0	system:role:add	#	admin	2023-09-18 10:20:15		\N	
1009	角色修改	101	3				1	0	F	0	0	system:role:edit	#	admin	2023-09-18 10:20:15		\N	
1010	角色删除	101	4				1	0	F	0	0	system:role:remove	#	admin	2023-09-18 10:20:15		\N	
1011	角色导出	101	5				1	0	F	0	0	system:role:export	#	admin	2023-09-18 10:20:15		\N	
1012	菜单查询	102	1				1	0	F	0	0	system:menu:query	#	admin	2023-09-18 10:20:15		\N	
1013	菜单新增	102	2				1	0	F	0	0	system:menu:add	#	admin	2023-09-18 10:20:15		\N	
1014	菜单修改	102	3				1	0	F	0	0	system:menu:edit	#	admin	2023-09-18 10:20:15		\N	
1015	菜单删除	102	4				1	0	F	0	0	system:menu:remove	#	admin	2023-09-18 10:20:15		\N	
1016	部门查询	103	1				1	0	F	0	0	system:dept:query	#	admin	2023-09-18 10:20:15		\N	
1017	部门新增	103	2				1	0	F	0	0	system:dept:add	#	admin	2023-09-18 10:20:15		\N	
1018	部门修改	103	3				1	0	F	0	0	system:dept:edit	#	admin	2023-09-18 10:20:15		\N	
1019	部门删除	103	4				1	0	F	0	0	system:dept:remove	#	admin	2023-09-18 10:20:15		\N	
1020	岗位查询	104	1				1	0	F	0	0	system:post:query	#	admin	2023-09-18 10:20:15		\N	
1021	岗位新增	104	2				1	0	F	0	0	system:post:add	#	admin	2023-09-18 10:20:15		\N	
1022	岗位修改	104	3				1	0	F	0	0	system:post:edit	#	admin	2023-09-18 10:20:15		\N	
1023	岗位删除	104	4				1	0	F	0	0	system:post:remove	#	admin	2023-09-18 10:20:15		\N	
1024	岗位导出	104	5				1	0	F	0	0	system:post:export	#	admin	2023-09-18 10:20:15		\N	
1025	字典查询	105	1	#			1	0	F	0	0	system:dict:query	#	admin	2023-09-18 10:20:15		\N	
1026	字典新增	105	2	#			1	0	F	0	0	system:dict:add	#	admin	2023-09-18 10:20:15		\N	
1027	字典修改	105	3	#			1	0	F	0	0	system:dict:edit	#	admin	2023-09-18 10:20:15		\N	
1028	字典删除	105	4	#			1	0	F	0	0	system:dict:remove	#	admin	2023-09-18 10:20:15		\N	
1029	字典导出	105	5	#			1	0	F	0	0	system:dict:export	#	admin	2023-09-18 10:20:15		\N	
1030	参数查询	106	1	#			1	0	F	0	0	system:config:query	#	admin	2023-09-18 10:20:15		\N	
1031	参数新增	106	2	#			1	0	F	0	0	system:config:add	#	admin	2023-09-18 10:20:15		\N	
1032	参数修改	106	3	#			1	0	F	0	0	system:config:edit	#	admin	2023-09-18 10:20:15		\N	
1033	参数删除	106	4	#			1	0	F	0	0	system:config:remove	#	admin	2023-09-18 10:20:15		\N	
1034	参数导出	106	5	#			1	0	F	0	0	system:config:export	#	admin	2023-09-18 10:20:15		\N	
1035	公告查询	107	1	#			1	0	F	0	0	system:notice:query	#	admin	2023-09-18 10:20:15		\N	
1036	公告新增	107	2	#			1	0	F	0	0	system:notice:add	#	admin	2023-09-18 10:20:15		\N	
1037	公告修改	107	3	#			1	0	F	0	0	system:notice:edit	#	admin	2023-09-18 10:20:15		\N	
1038	公告删除	107	4	#			1	0	F	0	0	system:notice:remove	#	admin	2023-09-18 10:20:15		\N	
1039	操作查询	500	1	#			1	0	F	0	0	monitor:operlog:query	#	admin	2023-09-18 10:20:15		\N	
1040	操作删除	500	2	#			1	0	F	0	0	monitor:operlog:remove	#	admin	2023-09-18 10:20:15		\N	
1041	日志导出	500	3	#			1	0	F	0	0	monitor:operlog:export	#	admin	2023-09-18 10:20:15		\N	
1042	登录查询	501	1	#			1	0	F	0	0	monitor:logininfor:query	#	admin	2023-09-18 10:20:15		\N	
1043	登录删除	501	2	#			1	0	F	0	0	monitor:logininfor:remove	#	admin	2023-09-18 10:20:15		\N	
1044	日志导出	501	3	#			1	0	F	0	0	monitor:logininfor:export	#	admin	2023-09-18 10:20:15		\N	
1045	账户解锁	501	4	#			1	0	F	0	0	monitor:logininfor:unlock	#	admin	2023-09-18 10:20:15		\N	
1046	在线查询	109	1	#			1	0	F	0	0	monitor:online:query	#	admin	2023-09-18 10:20:15		\N	
1047	批量强退	109	2	#			1	0	F	0	0	monitor:online:batchLogout	#	admin	2023-09-18 10:20:15		\N	
1048	单条强退	109	3	#			1	0	F	0	0	monitor:online:forceLogout	#	admin	2023-09-18 10:20:15		\N	
1049	任务查询	110	1	#			1	0	F	0	0	monitor:job:query	#	admin	2023-09-18 10:20:15		\N	
1050	任务新增	110	2	#			1	0	F	0	0	monitor:job:add	#	admin	2023-09-18 10:20:15		\N	
1051	任务修改	110	3	#			1	0	F	0	0	monitor:job:edit	#	admin	2023-09-18 10:20:15		\N	
1052	任务删除	110	4	#			1	0	F	0	0	monitor:job:remove	#	admin	2023-09-18 10:20:15		\N	
1053	状态修改	110	5	#			1	0	F	0	0	monitor:job:changeStatus	#	admin	2023-09-18 10:20:16		\N	
1054	任务导出	110	6	#			1	0	F	0	0	monitor:job:export	#	admin	2023-09-18 10:20:16		\N	
1055	生成查询	116	1	#			1	0	F	0	0	tool:gen:query	#	admin	2023-09-18 10:20:16		\N	
1056	生成修改	116	2	#			1	0	F	0	0	tool:gen:edit	#	admin	2023-09-18 10:20:16		\N	
1057	生成删除	116	3	#			1	0	F	0	0	tool:gen:remove	#	admin	2023-09-18 10:20:16		\N	
1058	导入代码	116	4	#			1	0	F	0	0	tool:gen:import	#	admin	2023-09-18 10:20:16		\N	
1059	预览代码	116	5	#			1	0	F	0	0	tool:gen:preview	#	admin	2023-09-18 10:20:16		\N	
1060	生成代码	116	6	#			1	0	F	0	0	tool:gen:code	#	admin	2023-09-18 10:20:16		\N	
\.


--
-- TOC entry 7106 (class 0 OID 16668)
-- Dependencies: 320
-- Data for Name: sys_notice; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_notice (notice_id, notice_title, notice_type, notice_content, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	温馨提醒：2018-07-01 若依新版本发布啦	2	\\xe696b0e78988e69cace58685e5aeb9	0	admin	2023-09-18 10:20:16		\N	管理员
2	维护通知：2018-07-01 若依系统凌晨维护	1	\\xe7bbb4e68aa4e58685e5aeb9	0	admin	2023-09-18 10:20:16		\N	管理员
\.


--
-- TOC entry 7107 (class 0 OID 16678)
-- Dependencies: 321
-- Data for Name: sys_oper_log; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time, cost_time) FROM stdin;
1	用户管理	2	com.ruoyi.web.controller.system.SysUserController.edit()	PUT	1	admin	\N	/system/user	192.168.52.1	内网IP	{"admin":false,"avatar":"","createBy":"admin","createTime":"2023-09-18 10:20:15","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":105,"deptName":"测试部门","leader":"若依","orderNum":3,"params":{},"parentId":101,"status":"0"},"deptId":105,"email":"ry@qq.com","loginDate":"2023-09-18 10:20:15","loginIp":"127.0.0.1","nickName":"瀚高","params":{},"phonenumber":"15666666666","postIds":[2],"remark":"测试员","roleIds":[2],"roles":[{"admin":false,"dataScope":"2","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}],"sex":"1","status":"0","updateBy":"admin","userId":2,"userName":"ry"}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 13:22:56.09386	38
2	用户管理	2	com.ruoyi.web.controller.system.SysUserController.edit()	PUT	1	admin	\N	/system/user	192.168.52.1	内网IP	{"admin":true,"avatar":"","createBy":"admin","createTime":"2023-09-18 10:20:15","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":103,"deptName":"研发部门","leader":"若依","orderNum":1,"params":{},"parentId":101,"status":"0"},"deptId":103,"email":"ry@163.com","loginDate":"2023-09-18 13:13:26.304","loginIp":"192.168.52.1","nickName":"瀚高管理员","params":{},"phonenumber":"15888888888","postIds":[1],"remark":"管理员","roleIds":[1],"roles":[{"admin":true,"dataScope":"1","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":1,"roleKey":"admin","roleName":"超级管理员","roleSort":1,"status":"0"}],"sex":"1","status":"0","userId":1,"userName":"admin"}	\N	1	不允许操作超级管理员用户	2023-09-18 13:23:31.195066	2
3	代码生成	6	com.ruoyi.generator.controller.GenController.importTableSave()	POST	1	admin	\N	/tool/gen/importTable	192.168.52.1	内网IP	{"tables":"t1"}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 13:28:04.865675	36
4	代码生成	2	com.ruoyi.generator.controller.GenController.synchDb()	GET	1	admin	\N	/tool/gen/synchDb/t1	192.168.52.1	内网IP	{}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 13:28:20.35031	29
5	代码生成	8	com.ruoyi.generator.controller.GenController.batchGenCode()	GET	1	admin	\N	/tool/gen/batchGenCode	192.168.52.1	内网IP	{"tables":"t1"}	\N	0	\N	2023-09-18 13:28:25.22628	43
6	定时任务	2	com.ruoyi.quartz.controller.SysJobController.changeStatus()	PUT	1	admin	\N	/monitor/job/changeStatus	192.168.52.1	内网IP	{"jobId":2,"misfirePolicy":"0","params":{},"status":"0"}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 13:29:07.143218	22
7	定时任务	2	com.ruoyi.quartz.controller.SysJobController.changeStatus()	PUT	1	admin	\N	/monitor/job/changeStatus	192.168.52.1	内网IP	{"jobId":2,"misfirePolicy":"0","params":{},"status":"1"}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 13:29:09.880819	13
8	代码生成	8	com.ruoyi.generator.controller.GenController.batchGenCode()	GET	1	admin	\N	/tool/gen/batchGenCode	192.168.52.1	内网IP	{"tables":"t1"}	\N	0	\N	2023-09-18 13:51:35.509921	157
9	代码生成	6	com.ruoyi.generator.controller.GenController.importTableSave()	POST	1	admin	\N	/tool/gen/importTable	192.168.52.1	内网IP	{"tables":"test"}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 13:51:55.405117	47
10	代码生成	8	com.ruoyi.generator.controller.GenController.batchGenCode()	GET	1	admin	\N	/tool/gen/batchGenCode	192.168.52.1	内网IP	{"tables":"test"}	\N	0	\N	2023-09-18 13:52:09.192793	43
11	代码生成	3	com.ruoyi.generator.controller.GenController.remove()	DELETE	1	admin	\N	/tool/gen/2	192.168.52.1	内网IP	{}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 13:55:27.915676	37
12	代码生成	6	com.ruoyi.generator.controller.GenController.importTableSave()	POST	1	admin	\N	/tool/gen/importTable	192.168.52.1	内网IP	{"tables":"part_2011"}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 13:55:46.107925	97
13	代码生成	2	com.ruoyi.generator.controller.GenController.synchDb()	GET	1	admin	\N	/tool/gen/synchDb/t1	192.168.52.1	内网IP	{}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 13:56:06.210539	41
14	代码生成	2	com.ruoyi.generator.controller.GenController.editSave()	PUT	1	admin	\N	/tool/gen	192.168.52.1	内网IP	{"businessName":"t1","className":"T1","columns":[{"capJavaField":"Id","columnComment":"序号","columnId":1,"columnName":"id","columnType":"integer","createBy":"admin","createTime":"2023-09-18 13:28:04","dictType":"","edit":false,"htmlType":"input","increment":false,"insert":true,"isIncrement":"0","isInsert":"1","isPk":"0","isRequired":"0","javaField":"id","javaType":"Long","list":false,"params":{},"pk":false,"query":false,"queryType":"EQ","required":false,"sort":1,"superColumn":false,"tableId":1,"updateBy":"","updateTime":"2023-09-18 13:56:06","usableColumn":false},{"capJavaField":"Name","columnComment":"人员名称","columnId":2,"columnName":"name","columnType":"character varying","createBy":"admin","createTime":"2023-09-18 13:28:04","dictType":"","edit":true,"increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"0","javaField":"name","javaType":"String","list":true,"params":{},"pk":false,"query":true,"queryType":"LIKE","required":false,"sort":2,"superColumn":false,"tableId":1,"updateBy":"","updateTime":"2023-09-18 13:56:06","usableColumn":false}],"crud":true,"functionAuthor":"ruoyi","functionName":"测试","genPath":"/","genType":"0","moduleName":"system","options":"{}","packageName":"com.ruoyi.system","params":{},"sub":false,"tableComment":"测试表","tableId":1,"tableName":"t1","tplCategory":"crud","tree":false}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 13:59:32.553318	27
15	用户头像	2	com.ruoyi.web.controller.system.SysProfileController.avatar()	POST	1	admin	\N	/system/user/profile/avatar	192.168.52.1	内网IP		{"msg":"操作成功","imgUrl":"/profile/avatar/2023/09/18/blob_20230918140801A001.png","code":200}	0	\N	2023-09-18 14:08:01.906978	147
16	个人信息	2	com.ruoyi.web.controller.system.SysProfileController.updateProfile()	PUT	1	admin	\N	/system/user/profile	192.168.52.1	内网IP	{"admin":true,"avatar":"","createBy":"admin","createTime":"2023-09-18 10:20:15","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":103,"deptName":"研发部门","leader":"若依","orderNum":1,"params":{"@type":"java.util.HashMap"},"parentId":101,"status":"0"},"deptId":103,"email":"hgdb@highgo.com","loginDate":"2023-09-18 13:12:03.068","loginIp":"127.0.0.1","nickName":"瀚高","params":{"@type":"java.util.HashMap"},"phonenumber":"18888888888","remark":"管理员","roles":[{"admin":true,"dataScope":"1","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{"@type":"java.util.HashMap"},"roleId":1,"roleKey":"admin","roleName":"超级管理员","roleSort":1,"status":"0"}],"sex":"0","status":"0","userId":1,"userName":"admin"}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 14:08:43.375244	21
17	个人信息	2	com.ruoyi.web.controller.system.SysProfileController.updateProfile()	PUT	1	admin	\N	/system/user/profile	192.168.52.1	内网IP	{"admin":true,"avatar":"","createBy":"admin","createTime":"2023-09-18 10:20:15","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":103,"deptName":"研发部门","leader":"若依","orderNum":1,"params":{"@type":"java.util.HashMap"},"parentId":101,"status":"0"},"deptId":103,"email":"hgdb@highgo.com","loginDate":"2023-09-18 13:12:03.068","loginIp":"127.0.0.1","nickName":"瀚高","params":{"@type":"java.util.HashMap"},"phonenumber":"18888888888","remark":"管理员","roles":[{"admin":true,"dataScope":"1","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{"@type":"java.util.HashMap"},"roleId":1,"roleKey":"admin","roleName":"超级管理员","roleSort":1,"status":"0"}],"sex":"0","status":"0","userId":1,"userName":"admin"}	{"msg":"操作成功","code":200}	0	\N	2023-09-18 14:08:47.144172	16
18	创建表	0	com.ruoyi.generator.controller.GenController.createTableSave()	POST	1	admin	研发部门	/tool/gen/createTable	127.0.0.1	内网IP	{"sql":"create table test(id int);"}	{"msg":"创建表结构异常","code":500}	0	\N	2024-08-29 15:34:49.883285	237
19	创建表	0	com.ruoyi.generator.controller.GenController.createTableSave()	POST	1	admin	研发部门	/tool/gen/createTable	127.0.0.1	内网IP	{"sql":"create table test(id int);"}	{"msg":"创建表结构异常","code":500}	0	\N	2024-08-29 15:37:22.56935	65
20	创建表	0	com.ruoyi.generator.controller.GenController.createTableSave()	POST	1	admin	研发部门	/tool/gen/createTable	127.0.0.1	内网IP	{"sql":"create table test(id int);"}	{"msg":"创建表结构异常","code":500}	0	\N	2024-08-29 15:37:49.575763	3
21	创建表	0	com.ruoyi.generator.controller.GenController.createTableSave()	POST	1	admin	研发部门	/tool/gen/createTable	127.0.0.1	内网IP	{"sql":"create table test(id int)"}	{"msg":"创建表结构异常","code":500}	0	\N	2024-08-29 15:38:17.168648	4
22	创建表	0	com.ruoyi.generator.controller.GenController.createTableSave()	POST	1	admin	研发部门	/tool/gen/createTable	127.0.0.1	内网IP	{"sql":"create table test(id int)"}	{"msg":"创建表结构异常，请检查SQL是否符合瀚高数据库语法。","code":500}	0	\N	2024-08-29 15:39:56.849587	283
23	创建表	0	com.ruoyi.generator.controller.GenController.createTableSave()	POST	1	admin	研发部门	/tool/gen/createTable	127.0.0.1	内网IP	{"sql":"create table test(id int)"}	{"msg":"创建表结构异常，请检查SQL是否符合瀚高数据库语法。","code":500}	0	\N	2024-08-29 15:40:00.280408	2
24	创建表	0	com.ruoyi.generator.controller.GenController.createTableSave()	POST	1	admin	研发部门	/tool/gen/createTable	127.0.0.1	内网IP	{"sql":"create table test(id int)"}	{"msg":"创建表结构异常，请检查SQL是否符合瀚高数据库语法。","code":500}	0	\N	2024-08-29 15:40:17.722591	3
25	创建表	0	com.ruoyi.generator.controller.GenController.createTableSave()	POST	1	admin	研发部门	/tool/gen/createTable	127.0.0.1	内网IP	{"sql":"create table test(id int)"}	{"msg":"创建表结构异常，请检查SQL是否符合瀚高数据库语法。","code":500}	0	\N	2024-08-29 15:55:51.921617	630756
26	创建表	0	com.ruoyi.generator.controller.GenController.createTableSave()	POST	1	admin	研发部门	/tool/gen/createTable	127.0.0.1	内网IP	{"sql":"create table test(id int);"}	{"msg":"操作成功","code":200}	0	\N	2024-08-29 15:58:27.288612	7697
27	代码生成	6	com.ruoyi.generator.controller.GenController.importTableSave()	POST	1	admin	研发部门	/tool/gen/importTable	127.0.0.1	内网IP	{"tables":"sys_config"}	{"msg":"操作成功","code":200}	0	\N	2024-08-29 15:58:47.722845	155
\.


--
-- TOC entry 7108 (class 0 OID 16700)
-- Dependencies: 322
-- Data for Name: sys_post; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	ceo	董事长	1	0	admin	2023-09-18 10:20:15		\N	
2	se	项目经理	2	0	admin	2023-09-18 10:20:15		\N	
3	hr	人力资源	3	0	admin	2023-09-18 10:20:15		\N	
4	user	普通员工	4	0	admin	2023-09-18 10:20:15		\N	
\.


--
-- TOC entry 7109 (class 0 OID 16709)
-- Dependencies: 323
-- Data for Name: sys_role; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_role (role_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	超级管理员	admin	1	1	1	1	0	0	admin	2023-09-18 10:20:15		\N	超级管理员
2	普通角色	common	2	2	1	1	0	0	admin	2023-09-18 10:20:15		\N	普通角色
\.


--
-- TOC entry 7110 (class 0 OID 16722)
-- Dependencies: 324
-- Data for Name: sys_role_dept; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_role_dept (role_id, dept_id) FROM stdin;
2	100
2	101
2	105
\.


--
-- TOC entry 7111 (class 0 OID 16725)
-- Dependencies: 325
-- Data for Name: sys_role_menu; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_role_menu (role_id, menu_id) FROM stdin;
2	1
2	2
2	3
2	4
2	100
2	101
2	102
2	103
2	104
2	105
2	106
2	107
2	108
2	109
2	110
2	111
2	112
2	113
2	114
2	115
2	116
2	117
2	500
2	501
2	1000
2	1001
2	1002
2	1003
2	1004
2	1005
2	1006
2	1007
2	1008
2	1009
2	1010
2	1011
2	1012
2	1013
2	1014
2	1015
2	1016
2	1017
2	1018
2	1019
2	1020
2	1021
2	1022
2	1023
2	1024
2	1025
2	1026
2	1027
2	1028
2	1029
2	1030
2	1031
2	1032
2	1033
2	1034
2	1035
2	1036
2	1037
2	1038
2	1039
2	1040
2	1041
2	1042
2	1043
2	1044
2	1045
2	1046
2	1047
2	1048
2	1049
2	1050
2	1051
2	1052
2	1053
2	1054
2	1055
2	1056
2	1057
2	1058
2	1059
2	1060
\.


--
-- TOC entry 7112 (class 0 OID 16728)
-- Dependencies: 326
-- Data for Name: sys_user; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark) FROM stdin;
2	105	ry	瀚高	00	ry@qq.com	15666666666	1		$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2	0	0	127.0.0.1	2023-09-18 10:20:15	admin	2023-09-18 10:20:15	admin	2023-09-18 13:22:56.025865	测试员
1	103	admin	瀚高	00	hgdb@highgo.com	18888888888	0	/profile/avatar/2023/09/18/blob_20230918140801A001.png	$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2	0	0	127.0.0.1	2024-08-29 15:32:50.895	admin	2023-09-18 10:20:15		2024-08-29 15:32:50.64172	管理员
\.


--
-- TOC entry 7113 (class 0 OID 16746)
-- Dependencies: 327
-- Data for Name: sys_user_post; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_user_post (user_id, post_id) FROM stdin;
1	1
2	2
\.


--
-- TOC entry 7114 (class 0 OID 16749)
-- Dependencies: 328
-- Data for Name: sys_user_role; Type: TABLE DATA; Schema: ruoyi2; Owner: ruoyi
--

COPY ruoyi2.sys_user_role (user_id, role_id) FROM stdin;
1	1
2	2
\.


--
-- TOC entry 7115 (class 0 OID 481257)
-- Dependencies: 525
-- Data for Name: test; Type: TABLE DATA; Schema: ruoyi2; Owner: sysdba
--

COPY ruoyi2.test (id) FROM stdin;
\.


--
-- TOC entry 7416 (class 0 OID 0)
-- Dependencies: 285
-- Name: seq_gen_table_column_column_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_gen_table_column_column_id', 65, true);


--
-- TOC entry 7417 (class 0 OID 0)
-- Dependencies: 283
-- Name: seq_gen_table_table_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_gen_table_table_id', 5, true);


--
-- TOC entry 7418 (class 0 OID 0)
-- Dependencies: 299
-- Name: seq_sys_config_config_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_config_config_id', 7, false);


--
-- TOC entry 7419 (class 0 OID 0)
-- Dependencies: 300
-- Name: seq_sys_dept_dept_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_dept_dept_id', 110, false);


--
-- TOC entry 7420 (class 0 OID 0)
-- Dependencies: 301
-- Name: seq_sys_dict_data_dict_code; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_dict_data_dict_code', 30, false);


--
-- TOC entry 7421 (class 0 OID 0)
-- Dependencies: 302
-- Name: seq_sys_dict_type_dict_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_dict_type_dict_id', 11, false);


--
-- TOC entry 7422 (class 0 OID 0)
-- Dependencies: 303
-- Name: seq_sys_job_job_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_job_job_id', 4, false);


--
-- TOC entry 7423 (class 0 OID 0)
-- Dependencies: 304
-- Name: seq_sys_job_log_job_log_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_job_log_job_log_id', 1, false);


--
-- TOC entry 7424 (class 0 OID 0)
-- Dependencies: 305
-- Name: seq_sys_logininfor_info_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_logininfor_info_id', 3, true);


--
-- TOC entry 7425 (class 0 OID 0)
-- Dependencies: 306
-- Name: seq_sys_menu_menu_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_menu_menu_id', 1061, false);


--
-- TOC entry 7426 (class 0 OID 0)
-- Dependencies: 307
-- Name: seq_sys_notice_notice_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_notice_notice_id', 3, false);


--
-- TOC entry 7427 (class 0 OID 0)
-- Dependencies: 308
-- Name: seq_sys_oper_log_oper_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_oper_log_oper_id', 27, true);


--
-- TOC entry 7428 (class 0 OID 0)
-- Dependencies: 309
-- Name: seq_sys_post_post_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_post_post_id', 5, false);


--
-- TOC entry 7429 (class 0 OID 0)
-- Dependencies: 310
-- Name: seq_sys_role_role_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_role_role_id', 3, false);


--
-- TOC entry 7430 (class 0 OID 0)
-- Dependencies: 311
-- Name: seq_sys_user_user_id; Type: SEQUENCE SET; Schema: ruoyi2; Owner: sysdba
--

SELECT pg_catalog.setval('ruoyi2.seq_sys_user_user_id', 3, false);


--
-- TOC entry 6828 (class 2606 OID 16753)
-- Name: gen_table_column gen_table_column_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.gen_table_column
    ADD CONSTRAINT gen_table_column_pkey PRIMARY KEY (column_id);


--
-- TOC entry 6826 (class 2606 OID 16755)
-- Name: gen_table gen_table_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.gen_table
    ADD CONSTRAINT gen_table_pkey PRIMARY KEY (table_id);


--
-- TOC entry 6830 (class 2606 OID 16757)
-- Name: qrtz_blob_triggers qrtz_blob_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_blob_triggers
    ADD CONSTRAINT qrtz_blob_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- TOC entry 6832 (class 2606 OID 16759)
-- Name: qrtz_calendars qrtz_calendars_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_calendars
    ADD CONSTRAINT qrtz_calendars_pkey PRIMARY KEY (sched_name, calendar_name);


--
-- TOC entry 6834 (class 2606 OID 16761)
-- Name: qrtz_cron_triggers qrtz_cron_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_cron_triggers
    ADD CONSTRAINT qrtz_cron_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- TOC entry 6836 (class 2606 OID 16763)
-- Name: qrtz_fired_triggers qrtz_fired_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_fired_triggers
    ADD CONSTRAINT qrtz_fired_triggers_pkey PRIMARY KEY (sched_name, entry_id);


--
-- TOC entry 6838 (class 2606 OID 16765)
-- Name: qrtz_job_details qrtz_job_details_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_job_details
    ADD CONSTRAINT qrtz_job_details_pkey PRIMARY KEY (sched_name, job_name, job_group);


--
-- TOC entry 6840 (class 2606 OID 16767)
-- Name: qrtz_locks qrtz_locks_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_locks
    ADD CONSTRAINT qrtz_locks_pkey PRIMARY KEY (sched_name, lock_name);


--
-- TOC entry 6842 (class 2606 OID 16769)
-- Name: qrtz_paused_trigger_grps qrtz_paused_trigger_grps_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_paused_trigger_grps
    ADD CONSTRAINT qrtz_paused_trigger_grps_pkey PRIMARY KEY (sched_name, trigger_group);


--
-- TOC entry 6844 (class 2606 OID 16771)
-- Name: qrtz_scheduler_state qrtz_scheduler_state_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_scheduler_state
    ADD CONSTRAINT qrtz_scheduler_state_pkey PRIMARY KEY (sched_name, instance_name);


--
-- TOC entry 6846 (class 2606 OID 16773)
-- Name: qrtz_simple_triggers qrtz_simple_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_simple_triggers
    ADD CONSTRAINT qrtz_simple_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- TOC entry 6848 (class 2606 OID 16775)
-- Name: qrtz_simprop_triggers qrtz_simprop_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_simprop_triggers
    ADD CONSTRAINT qrtz_simprop_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- TOC entry 6850 (class 2606 OID 16777)
-- Name: qrtz_triggers qrtz_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_triggers
    ADD CONSTRAINT qrtz_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- TOC entry 6853 (class 2606 OID 16779)
-- Name: sys_config sys_config_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_config
    ADD CONSTRAINT sys_config_pkey PRIMARY KEY (config_id);


--
-- TOC entry 6855 (class 2606 OID 16781)
-- Name: sys_dept sys_dept_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_dept
    ADD CONSTRAINT sys_dept_pkey PRIMARY KEY (dept_id);


--
-- TOC entry 6857 (class 2606 OID 16783)
-- Name: sys_dict_data sys_dict_data_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_dict_data
    ADD CONSTRAINT sys_dict_data_pkey PRIMARY KEY (dict_code);


--
-- TOC entry 6859 (class 2606 OID 16785)
-- Name: sys_dict_type sys_dict_type_dict_type; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_dict_type
    ADD CONSTRAINT sys_dict_type_dict_type UNIQUE (dict_type);


--
-- TOC entry 6861 (class 2606 OID 16787)
-- Name: sys_dict_type sys_dict_type_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_dict_type
    ADD CONSTRAINT sys_dict_type_pkey PRIMARY KEY (dict_id);


--
-- TOC entry 6865 (class 2606 OID 16789)
-- Name: sys_job_log sys_job_log_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_job_log
    ADD CONSTRAINT sys_job_log_pkey PRIMARY KEY (job_log_id);


--
-- TOC entry 6863 (class 2606 OID 16791)
-- Name: sys_job sys_job_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_job
    ADD CONSTRAINT sys_job_pkey PRIMARY KEY (job_id, job_name, job_group);


--
-- TOC entry 6867 (class 2606 OID 16793)
-- Name: sys_logininfor sys_logininfor_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_logininfor
    ADD CONSTRAINT sys_logininfor_pkey PRIMARY KEY (info_id);


--
-- TOC entry 6871 (class 2606 OID 16795)
-- Name: sys_menu sys_menu_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_menu
    ADD CONSTRAINT sys_menu_pkey PRIMARY KEY (menu_id);


--
-- TOC entry 6873 (class 2606 OID 16797)
-- Name: sys_notice sys_notice_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_notice
    ADD CONSTRAINT sys_notice_pkey PRIMARY KEY (notice_id);


--
-- TOC entry 6875 (class 2606 OID 16799)
-- Name: sys_oper_log sys_oper_log_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_oper_log
    ADD CONSTRAINT sys_oper_log_pkey PRIMARY KEY (oper_id);


--
-- TOC entry 6880 (class 2606 OID 16801)
-- Name: sys_post sys_post_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_post
    ADD CONSTRAINT sys_post_pkey PRIMARY KEY (post_id);


--
-- TOC entry 6884 (class 2606 OID 16803)
-- Name: sys_role_dept sys_role_dept_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_role_dept
    ADD CONSTRAINT sys_role_dept_pkey PRIMARY KEY (role_id, dept_id);


--
-- TOC entry 6886 (class 2606 OID 16805)
-- Name: sys_role_menu sys_role_menu_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_role_menu
    ADD CONSTRAINT sys_role_menu_pkey PRIMARY KEY (role_id, menu_id);


--
-- TOC entry 6882 (class 2606 OID 16807)
-- Name: sys_role sys_role_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_role
    ADD CONSTRAINT sys_role_pkey PRIMARY KEY (role_id);


--
-- TOC entry 6888 (class 2606 OID 16809)
-- Name: sys_user sys_user_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_user
    ADD CONSTRAINT sys_user_pkey PRIMARY KEY (user_id);


--
-- TOC entry 6890 (class 2606 OID 16811)
-- Name: sys_user_post sys_user_post_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_user_post
    ADD CONSTRAINT sys_user_post_pkey PRIMARY KEY (user_id, post_id);


--
-- TOC entry 6892 (class 2606 OID 16813)
-- Name: sys_user_role sys_user_role_pkey; Type: CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.sys_user_role
    ADD CONSTRAINT sys_user_role_pkey PRIMARY KEY (user_id, role_id);


--
-- TOC entry 6851 (class 1259 OID 16814)
-- Name: qrtz_triggerssched_name; Type: INDEX; Schema: ruoyi2; Owner: ruoyi
--

CREATE INDEX qrtz_triggerssched_name ON ruoyi2.qrtz_triggers USING btree (sched_name, job_name, job_group);


--
-- TOC entry 6868 (class 1259 OID 16815)
-- Name: sys_logininforidx_sys_logininfor_lt; Type: INDEX; Schema: ruoyi2; Owner: ruoyi
--

CREATE INDEX sys_logininforidx_sys_logininfor_lt ON ruoyi2.sys_logininfor USING btree (login_time);


--
-- TOC entry 6869 (class 1259 OID 16816)
-- Name: sys_logininforidx_sys_logininfor_s; Type: INDEX; Schema: ruoyi2; Owner: ruoyi
--

CREATE INDEX sys_logininforidx_sys_logininfor_s ON ruoyi2.sys_logininfor USING btree (status);


--
-- TOC entry 6876 (class 1259 OID 16817)
-- Name: sys_oper_logidx_sys_oper_log_bt; Type: INDEX; Schema: ruoyi2; Owner: ruoyi
--

CREATE INDEX sys_oper_logidx_sys_oper_log_bt ON ruoyi2.sys_oper_log USING btree (business_type);


--
-- TOC entry 6877 (class 1259 OID 16818)
-- Name: sys_oper_logidx_sys_oper_log_ot; Type: INDEX; Schema: ruoyi2; Owner: ruoyi
--

CREATE INDEX sys_oper_logidx_sys_oper_log_ot ON ruoyi2.sys_oper_log USING btree (oper_time);


--
-- TOC entry 6878 (class 1259 OID 16819)
-- Name: sys_oper_logidx_sys_oper_log_s; Type: INDEX; Schema: ruoyi2; Owner: ruoyi
--

CREATE INDEX sys_oper_logidx_sys_oper_log_s ON ruoyi2.sys_oper_log USING btree (status);


--
-- TOC entry 6893 (class 2606 OID 16820)
-- Name: qrtz_blob_triggers qrtz_blob_triggers_ibfk_1; Type: FK CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_blob_triggers
    ADD CONSTRAINT qrtz_blob_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ruoyi2.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- TOC entry 6894 (class 2606 OID 16825)
-- Name: qrtz_cron_triggers qrtz_cron_triggers_ibfk_1; Type: FK CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_cron_triggers
    ADD CONSTRAINT qrtz_cron_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ruoyi2.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- TOC entry 6895 (class 2606 OID 16830)
-- Name: qrtz_simple_triggers qrtz_simple_triggers_ibfk_1; Type: FK CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_simple_triggers
    ADD CONSTRAINT qrtz_simple_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ruoyi2.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- TOC entry 6896 (class 2606 OID 16835)
-- Name: qrtz_simprop_triggers qrtz_simprop_triggers_ibfk_1; Type: FK CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_simprop_triggers
    ADD CONSTRAINT qrtz_simprop_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ruoyi2.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- TOC entry 6897 (class 2606 OID 16840)
-- Name: qrtz_triggers qrtz_triggers_ibfk_1; Type: FK CONSTRAINT; Schema: ruoyi2; Owner: ruoyi
--

ALTER TABLE ONLY ruoyi2.qrtz_triggers
    ADD CONSTRAINT qrtz_triggers_ibfk_1 FOREIGN KEY (sched_name, job_name, job_group) REFERENCES ruoyi2.qrtz_job_details(sched_name, job_name, job_group);


-- Completed on 2024-08-29 16:12:41

--
-- PostgreSQL database dump complete
--

